Find the RANGE in MOUSE CLICK
 

Dear All,
In my program, RANGE will be change eveytime.Like first time A1:B35 , Next
time B2:D234, 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.

Find the RANGE in MOUSE CLICK
 

sub ShowRange()
msgbox selection.address
end sub

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Avadivelan TCS" wrote:

Dear All,
In my program, RANGE will be change eveytime.Like first time A1:B35 , Next
time B2:D234, 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.

Find the RANGE in MOUSE CLICK
 

Thanks a lot.

"Gary L Brown" wrote:

sub ShowRange()
msgbox selection.address
end sub

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Avadivelan TCS" wrote:

Dear All,
In my program, RANGE will be change eveytime.Like first time A1:B35 , Next
time B2:D234, 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.