Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lose selected range when I right click | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Excel 2003 Mouse Right Click | Excel Worksheet Functions | |||
Find cell contents in range | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions |