Const whatColumn as String = "A"
Dim lastrow
lastrow = Range(whatColumn & Rows.Count).End(xlUp).Row

"jlclyde" wrote:

I am trying to write some VBA to use the row number of the last cell
in selection as a variable. How do you set this as a variable?

Thanks,
Jay