View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 276
Default Modify to only work with nominated range instead of entire sheet

~~~~~~~~~~~~~~~~~~~~~~~
Dim c As Range
For Each c In Sheets("REPORT").UsedRange
If c.Locked = False Then c.Value = ""
Next c
End If
~~~~~~~~~~~~~~~~~~~~~~
The above code clears all cells in a sheet(REPORT) that are Not Locked.
However it seem to take a while to process.

How could i add a line to ONLY refer to a range of ( A1:AC960) instead of
the entire sheet ?


--
Corey ....
The Silliest Question is generally
the one i forgot to ask.