'What is the opposite of .Cells(.Rows.Count, 1).End(xlUp).Row

I was using .Cells(.Rows.Count, 1).End(xlUp).Row to stop at the last non empty row but I was wondering how do I stop at a specific row instead eg. the row 500?

with WS_Output
    lrow_output = .Cells(.Rows.Count, 1).End(xlUp).Row

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'What is the opposite of .Cells(.Rows.Count, 1).End(xlUp).Row

Sources

Related Questions