cjvenables
Board Regular
- Joined
- Aug 2, 2011
- Messages
- 65
Hello,
I have a report that runs that returns a different number of rows throughout the month. All columns have the same rows of data, but at the bottom of the report, there is a space in Column A and then there are 4 rows of data after that I want to delete.
I need the VBA code to find the range from A1:The last row of data in Column BN. After, I need it to skip 1 space, and then delete the next 4 rows.
Here is a little example:
Column A
Data
Data
Data
Data
Space
Line 1 Delete
Line 2 Delete
Line 3 Delete
Line 4 Delete
Thanks!
I have a report that runs that returns a different number of rows throughout the month. All columns have the same rows of data, but at the bottom of the report, there is a space in Column A and then there are 4 rows of data after that I want to delete.
I need the VBA code to find the range from A1:The last row of data in Column BN. After, I need it to skip 1 space, and then delete the next 4 rows.
Here is a little example:
Column A
Data
Data
Data
Data
Space
Line 1 Delete
Line 2 Delete
Line 3 Delete
Line 4 Delete
Thanks!