Multiple lastrow designations in a single Sub

[ahuang3433]

Can you have multiple Dim lastrow within a single Sub? In my current code, it dragging the formula down but not to the last row so that's why I'm asking. This scenario is being tested on Column X formula.

Please Login or Register  to view this content.

[ahuang3433]

Never mind. I solved it. I just had to put my sheet call out before the Dim Lastrrow designation.