Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to specify a range in VBA based on values in cells
I'm a novice trying to build a macro that will select a range based on
values from calculated cells on a worksheet. The macro should select a range denoted by the values of the two calculated cells in the same row as the active cell. Thanks in advance for your advice. Donald Prebus Vancouver WA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to specify a range in VBA based on values in cells
Donald
not much detail of how you specify the cells so, you'll need something like: Range(Range("A1").value & ":" & Range("A2").Value).Select Where A1 contains a cell reference, for example, B1. Cell A2 contains the next cell, for example, G17. In this case the range B1 to G17 will be selected. Regards Trevor "Comcast Mail" wrote in message ... I'm a novice trying to build a macro that will select a range based on values from calculated cells on a worksheet. The macro should select a range denoted by the values of the two calculated cells in the same row as the active cell. Thanks in advance for your advice. Donald Prebus Vancouver WA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally Formatting Cells based on Values in a Range (2007) | Excel Worksheet Functions | |||
Backgroud color for 1 cell based on a range of cells values | Excel Discussion (Misc queries) | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Sum values in columns based on values in named range | Excel Worksheet Functions | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |