View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nathan Gutman Nathan Gutman is offline
external usenet poster
 
Posts: 31
Default 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