| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifying a Selected Range in a Macro
When a user clicks and drags to highlight a range, how do I identify that range in a macro? Say the user highlights cells E6:G17, I want to give them the ability to click a button that will do several things to that range. I have tested my macro, but only when I have used a known range. -- DCSwearingen ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=535965 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format macro | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Name a Range - Macro | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
Threaded Mode
