Hi all,
Please advise on the best script to clear all non-blank cells, in my case from Cells(7,1) forward. I currently use this:
Will this scipt take a lot of memory to execute? Is there any other method?
Tks a lot!
Please advise on the best script to clear all non-blank cells, in my case from Cells(7,1) forward. I currently use this:
.Range(Cells(7, Columns.Count), Cells(Rows.Count, 1)).Value = ""
Will this scipt take a lot of memory to execute? Is there any other method?
Tks a lot!