How to get last row variable to update

[LtCmdrData]

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.

 

[Fluff]

Depending on your actual code, you can probably just reset the lr variable.

 

[LtCmdrData]

How do I reset the lr variable? Or any variable? I've never done this before.

 

[Fluff]

Exactly the same way you give it a value initially.

 

[LtCmdrData]

So it's as simple as repeating the same line of code, the DIM statement and the lr = Cells(Rows.Count, "A").End(xlUp).Row code? Wow. Does this work for most or all variables?

 

[Gokhan Aycan]

Not Dim part, you declare it once, although a Dim inside a loop is ok.

 

[Fluff]

You just need to repeat this part

lr = Cells(Rows.Count, "A").End(xlUp).Row

 

[MARK858]

although a Dim inside a loop is ok.

Why make Excel reassign it multiple times to the same data type? The memory usage is miniscule but is unnecessary.

 

[Gokhan Aycan]

Why make Excel reassign it multiple times to the same data type? The memory usage is miniscule but is unnecessary.

I wasn't very explicit, so that's on me. What I tried to mean was it won't throw an error in that case.

 

[LtCmdrData]

I tried just restating the variable again and it worked. I had no idea to solutions was this simple. Thank you Fluff and thank you Gokhan Aycan for the guidance and solution.