| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variables to select a range
I am trying to pull a number from a cell and use it to select a range of cells
Dim days as integer days = range("A1").value range(B1:C & days).select what is the exact syntax including any other line of code required. Assume I know nothing. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using variables to select a range
close!
Try range("B1:C" & days).select Tim "Marc" wrote in message ... I am trying to pull a number from a cell and use it to select a range of cells Dim days as integer days = range("A1").value range(B1:C & days).select what is the exact syntax including any other line of code required. Assume I know nothing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| How do I select on two variables in a range of data in excel | Excel Worksheet Functions | |||
| Select one variable from a list of variables by clicking one cell | Excel Discussion (Misc queries) | |||
| Range.Select Using Variables - need syntax | Excel Discussion (Misc queries) | |||
| Range Variables | Excel Programming | |||
![Marc[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
