tqm1
06-22-2007, 05:31 AM
Dear Experts
I use following codes to clear data from range("a6") to lastrow
With Sheets("Rpt_Daily")
Range(.Cells(6, 1), .Cells(65536,1).End(xlUp)).EntireRow.ClearContents
End with
But it only clear data, not format.
How to clear Data and Format within given range?
I want to clear (data + borders + color etc)
Please help
I use following codes to clear data from range("a6") to lastrow
With Sheets("Rpt_Daily")
Range(.Cells(6, 1), .Cells(65536,1).End(xlUp)).EntireRow.ClearContents
End with
But it only clear data, not format.
How to clear Data and Format within given range?
I want to clear (data + borders + color etc)
Please help