Vba to clear a range including hidden cells?

[tonywatsonhelp]

Hi Everyone,

Not sure if this is harder than it sounds but i have a range that can have different rows hidden each time.

So the range is E:50:M250 now all I want is a macro that can clear the entire range including the hidden cells

So I want VBA Activesheet.range("E50:E250").clearcontents (including hidden rows)

please help if you can thanks

Tony

 

[Norie]

Tony

The code you posted should work, is it not clearing the hidden cells?

 

[tonywatsonhelp]

HI Norrie,
I thought it should and you are correct it does, I'm just having a brain dead day.
You can all have a good laugh at this I did.
Instead of

Activesheet.range("E50:E250").clearcontents​

I typed

Activesheet.range("E50:E250").clearcomments !!!!
I suppose to get the code to work it helps if you can spell LOL
thanks for your help I'd never have spotted it otherwise.
Tony _{^{<strike>
</strike>}}​