| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using an Input Box To Define a Range
I am trying to set a variable to a range by using an input box. Basically
it's a macro that will ask a user what range of cells the data they are looking for is in, but I can't seem to get it. I tried it once and entered C1:C120 into the input box but then I got an error that said Object variable not set (and the debug highlight was on the input box for the range. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define variable range input for SUM() function | Excel Worksheet Functions | |||
| Can I use a text input to define another file to reference? | Excel Discussion (Misc queries) | |||
| Define Range in VBA | Excel Programming | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Threaded Mode
