Select last cell in Selection
 

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

Select last cell in Selection
 

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

Select last cell in Selection
 

Hi

myrow = Selection(Selection.Count).Row

Mike

"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

Select last cell in Selection
 

On Jun 27, 3:04*pm, Mike H wrote:
Hi

myrow = Selection(Selection.Count).Row

Mike



"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- Hide quoted text -

- Show quoted text -

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

Thank you for that.

Jay

Select last cell in Selection
 

Your welcome and thanks for the feedback

Mike

"jlclyde" wrote:

On Jun 27, 3:04 pm, Mike H wrote:
Hi

myrow = Selection(Selection.Count).Row

Mike



"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- Hide quoted text -

- Show quoted text -

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

Thank you for that.

Jay