VBA to Delete Specific # of Rows

[Sundae]

Hi,

I am sure this is an easy one for you gurus, but since I am new to VBA I am having trouble:

How do I write code to delete the row of the current cell activated plus the 4 rows below?

Thanks!

 

[Rick Rothstein]

This single line of code will do what you asked for...

ActiveCell.Rows.Resize(5).EntireRow.Delete

Put it in your macro at whatever location you need it to be at.

 

[Sundae]

Thank you - you have been a great help to me in my learning VBA. I have another post titled "Loop Question" that I have had no replies to. Everyone on this great forum is normally so quick reply. Any chance you could look at it?

Thanks!