View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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