| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA range from cell value
I have a macro in which I have the line:
Range (A1:I8).select The problem is that the row number in Col. I varies. I would like to get the range from cell L2 in my worksheet and continue the rest of the macro. I can make the proper range in cell L2 I just need to know how to make visual basic look at that cell to determine the range it selects. Can anyone help me? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA range from cell value
If you're saying you create a text reference to the range (e.g.,
"A1:I100") in cell L2, then use Range(Range("L2").Text).Select But I'd guess it would be more efficient to calculate the row number in VBA directly. Post back explaining how you come up with the method if you're interested. In article , "Alex" wrote: I have a macro in which I have the line: Range (A1:I8).select The problem is that the row number in Col. I varies. I would like to get the range from cell L2 in my worksheet and continue the rest of the macro. I can make the proper range in cell L2 I just need to know how to make visual basic look at that cell to determine the range it selects. Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
Linear Mode
