Select last cell in Selection

[jlclyde]

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

 

[Mike]

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

 

[Mike H]

Hi

myrow = Selection(Selection.Count).Row

Mike

 

[jlclyde]

Hi

myrow = Selection(Selection.Count).Row

Mike






- Show quoted text -

Mike H. ,
That is way too simple. I am glad I know that now.

Thank you for that.

Jay

 

[Mike H]

Your welcome and thanks for the feedback

Mike

Mike H. ,
That is way too simple. I am glad I know that now.

Thank you for that.

Jay