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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a variable Range
Maybe????
p = Range("startdate").Value q = Range("enddate").Value Sheets("Data-Sales w Macro").Select range(Range("G29").Offset(0, p),range("g29").offset(0,q)).select Brett wrote: 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. -- Dave Peterson |
Reply |
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 |