View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RW RW is offline
external usenet poster
 
Posts: 49
Default Delete selected range

Here's the code

Set WshD = ThisWorkBook.WorkSheets("index")
Set RngD = WshD.Range("M65536".End(xlUP)
RngD = RngD.Offset(0,-12).Resize(11,12).Delete

I've also used Select in place of Delete above and then added
Selection.Delete on the next line.
I used the Offset before resize since I read in this forum that Resize
doesn't like negative values.

How do I delete the newly selected range?