| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Active range/selection?
Hi,
I would like to have a macro which picks up my selected range in a workbook, similair to the activecell. So when I select a range in my workbook, it will be set as range in my macro. I've tried active.range but this doens't work (something like this: Set dd = Active.Range). I can't find it in the list properties/methods in vba. Could somebody help me? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| jump to active cell in other sheet . | Excel Discussion (Misc queries) | |||
| HOW TO COLOR ACTIVE LINE CURSOR IS ON WHEN MOVING | Excel Discussion (Misc queries) | |||
| How do I have an active cell highlight automatically | Excel Discussion (Misc queries) | |||
| HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
| Unable to set the active cell from VBA | New Users to Excel | |||
Threaded Mode
