Thread: Using Rows().Delete
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hafeez Esmail Hafeez Esmail is offline
external usenet poster
  
Posts: 22
Default Using Rows().Delete
How do I delete n rows after the row of the current cell?
Example:
current cell = A17
n = 3
How do I delete rows 18, 19 and 20?

This is what I have, but it's wrong...

rows(activecell.row + 1:activecell.row + intNum).delete
(xlshiftup)

Help Please
Hafeez Esmail
Reply With QuoteReply With Quote