wilkisa
Well-known Member
- Joined
- Apr 7, 2002
- Messages
- 657
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
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
Thank you,
Shirlene