Special Clearcontents (Values Only) 1

[vestax22]

Hi, I use this line of code to erase only the values and not the formulas inside a range :

Worksheets("Months1&quot.Range("months1Inputs&quot.SpecialCells(xlCellTypeConstants).ClearContents

It works great except that when there is no data to erase it crashes. When I do a regular clearcontents It doesn't crash when there is no data to erase. Is there anybody that knows the solution to this problem?

Thx

 

[xlbo]

just put
on error resume next
before that line and
On error goto 0
after it (to turn off the resume next for the rest of the sub)

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[Loomah]

Hi
See my reply in your last thread on this subject (thread707-600337). It's a (easily) trappable error!
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[Loomah]

I don't know. My only posting for about a week and you still have to jump in infront of me!!!!!!!!!!!
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[xlbo]

sorry Loomah - I'm not picking on you on purpose

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244