JustinCase
New Member
- Joined
- Jul 22, 2010
- Messages
- 9
Hi all,
I'm looking at clearing all contents of a set cell range on multiple tabs
so was looking along the lines of ;
Worksheets(Array("ABCD", "UFDHD", "FGHDFHFD", "EWDHFGH")).Select
.Range("L2:P13").ClearContents
However i've missed a part out, and its driving me insane.
Is there also a better way to mark all worksheets as a varient so i can just call on for example worksheets(x)
Cheers.
I'm looking at clearing all contents of a set cell range on multiple tabs
so was looking along the lines of ;
Worksheets(Array("ABCD", "UFDHD", "FGHDFHFD", "EWDHFGH")).Select
.Range("L2:P13").ClearContents
However i've missed a part out, and its driving me insane.
Is there also a better way to mark all worksheets as a varient so i can just call on for example worksheets(x)
Cheers.