looping clearcontents through all worksheets

**kchm_2000** · 10-19-2011, 01:44 AM

Hi,

I have a code that aims to clear contents on col F and G, and for sheets that begin with ACD. However when i an the macro it only seems to clear contents on the current sheet that I am on. Thanks in advance to anyone we will be helping me

Please Login or Register  to view this content.

**royUK** · 10-19-2011, 02:16 AM

When you use a With statement you need to let Excel know that it is working on that sheet or range. Also, you don't need to select. So your code should be

Please Login or Register  to view this content.

**kchm_2000** · 10-19-2011, 04:46 AM

Thanks, i understand better now

**royUK** · 10-19-2011, 08:13 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save