How to clear a selection
Hello Bob,
You one-liner worked beautifully! In my case I just used
ActiveSheet.Cells(...
Would you care to explain what is doing what here.
Thanks again,
Nathan
On Wed, 25 Feb 2004 20:34:52 -0000, "Bob Phillips"
wrote:
Good Evening Nathan,
A simple one-liner
Worksheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(-2,
0).Resize(3, 1).ClearContents
|