Need help with dynamic range macro

[wilkisa]

I'm needing a macro that will Delete ShiftUP the same size range but in different areas of the worksheet. The range will always begin in Col A and end in Col H and will always be 21 rows long. I've tried various different macros but can't get it to understand the active cell is where to start and I don't know how to select the remaining range without the macros using that range for each use. I'm sure it is simple but I've been away from Excel over a year and I can't believe the layer of rust that's on my memory! Any help provided is gratefully accepted.

Thank you,
Shirlene

 

[Fazza]

maybe
Cells(ActiveCell.Row, 1).Resize(21, 8).Delete Shift:=xlUp

 

[wilkisa]

Thank you, Fazza! It was RESIZE I had forgotten about. This is exactly what I wanted. I appreciate it!

 

[Fazza]

you're welcome, Shirlene. regards, Fazza