Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select contents of entire worksheet
I'm trying to clear the contents of an entire worksheet
from a macro but I can't find any way of doing this. I don't want to delete the sheet only clear the contents. I've gone round in circles with the range(???).clearcontents style as I can only see that defining the maximum number of possible cells (ie range("A1:IV65536").clearcontents) will ensure that the whole sheet is cleared. Am I just missing something obvious ? or is this the way to do it. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy entire contents worksheet into new workbook, link but editabl | Excel Discussion (Misc queries) | |||
Using Cell Contents to Select Worksheet with Same Name as Cell Con | Excel Worksheet Functions | |||
why does this macro select the entire worksheet when run? | Excel Discussion (Misc queries) | |||
Select the entire row | Excel Discussion (Misc queries) | |||
Printing Entire Contents of Cell | Excel Discussion (Misc queries) |