Guzzlr
Well-known Member
- Joined
- Apr 20, 2009
- Messages
- 982
- Office Version
- 2021
- Platform
- Windows
Hello
I have:
I'm getting this error:
What I am wanting, is to use column A, and drop to the bottom and delete all rows up to where the data starts.
I was using A5, because that is where the data header begins. There are some blank cells before A5, so I was not sure if I can simply use Range ("A:A") due to a couple of blank cells in column A above A5.
Where is my mistake that is causing this error?
Thank you for the help
I have:
VBA Code:
Range("A5").End(xlDown).Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count).EntireRow.Delete
I'm getting this error:
What I am wanting, is to use column A, and drop to the bottom and delete all rows up to where the data starts.
I was using A5, because that is where the data header begins. There are some blank cells before A5, so I was not sure if I can simply use Range ("A:A") due to a couple of blank cells in column A above A5.
Where is my mistake that is causing this error?
Thank you for the help