Clear cell with out calling worksheet_selectionchange event

[wwgmr]

Hi all, I am wanting to clear cells on a sheet that have a Worksheet_selectionchange event tied to them when someone clicks on that cell.

In my code for resetting the spread sheet, I am selecting many cells with range("Multible cell address&quot.select to then clear selected. My problem is it causes the selection change event which I don't want to happen. Is there a way to avoid this and clear the contents of the cells?

Thanks!

 

[SkipVought]

Why are you using Select?

MyRange.ClearContents

faq707-4105 How Can I Make My Code Run Faster?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[RobBroekhuis]

Yes, don't select the cells. Just do
range("Multiple cell address&quot.clear
In other cases, where it may not be quite so simple, you can also set
application.enableevents=false
for the duration of the event handler. But that's really not necessary in your case.


Rob

 

[Chattin]

Without knowing too much about your code for resetting the spreadsheet try Application.EnableEvents=False at the start and set to True at the end of your macro?

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[wwgmr]

Thanks that helps, I was using the Macro recorder thats why I used select. Thanks again for help