Find the RANGE in MOUSE CLICK

[Avadivelan TCS]

Dear All,
In my program, RANGE will be change eveytime.Like first time A1:B35 , Next
time B2234, Third time C22:E46, ..etc. So that can you suggest how to
store(find) the RANGE using Mouse Selection in a variable.
Have a nice day to all..! Thanks in advance for your reply.

 

[Gary L Brown]

sub ShowRange()
msgbox selection.address
end sub

HTH,

 

[Avadivelan TCS]

Thanks a lot.

sub ShowRange()
msgbox selection.address
end sub

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.