Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlUnlockedCells ClearContents Possible ?
I have a userform to input values into a sheet.
Now after either previewing the sheet, or printing it, i have the need to now remove the values(many) that were placed into the sheet. Rather than tediously entering each cell by name, is there a way to clearcontents of ALL cells that are Unlocked in the sheet ? I tried: with sheets("Inspections") if xlUnlockedCells = True then xlUnlockedCells.ClearContents end with But i get an error. Is there a way i can code this ? Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EnableSelection = xlUnlockedCells | Excel Programming | |||
Clearcontents | Excel Programming | |||
.EnableSelection = xlUnlockedCells | Excel Programming | |||
Clearcontents | Excel Programming | |||
Clearcontents | Excel Programming |