Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a variable Range
Hi everyone,
I am having issues selecting a variable range. This is basic but I am not a heavy user of VBA. p = Range("startdate").Value q = Range("enddate").Value Sheets("Data-Sales w Macro").Select Range("G29").Offset(0, p).Select I am attempting to select the range between and including P and Q. P and Q are drop down boxes. The code above selects the cell from startdate, but my problem is the rest. Sorry for the easy question. I appreciate your answers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro syntax for selecting variable range | Excel Discussion (Misc queries) | |||
Selecting Variable Rows | Excel Programming | |||
Selecting a row with a variable ? | Excel Programming | |||
Selecting Variable Row Range w/Macro | Excel Programming | |||
Selecting a Range Using a Variable | Excel Programming |