Thread: Delete Rows x-n
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Delete Rows x-n

i have a simple question to go with yours........ if you don't provide
the end of the range that you are deleting, how in the world will the
macro know where to stop?????
:)
susan


On Jul 21, 11:17*am, Lars Uffmann wrote:
Hi everyone!

What I want to do is basically
* * Worksheet.Rows.Delete xlShiftUp
except that I do not want to delete the headings row.

So something like
* * Worksheet.Rows.Delete (2)
to delete starting from row 2, without having to provide the end of the
range that I am deleting.

Simple question - is there a simple answer?

Thanks!

* * Lars