View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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