LtCmdrData
Board Regular
- Joined
- Jan 24, 2018
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
I'm still trying to learn VBA so I hope someone can help me please. I have some rows of data that I need to clean up. I set a variable, lr = Cells(Rows.Count, "A").End(xlUp).Row, to determine how many rows are in my data set based on column A. First I want to delete any blank rows and then I want to filter for certain criteria and delete more rows. Since the total number of rows keeps changing, here is my dilemma: How do I get my variable (lr) to update to the new number of rows? My work around has been to declare a new variable, such as lrow, every time my data set changes. I know there must be a better way of doing this but I don't know what I don't know. I would appreciate any help and guidance someone could offer. Thank you.