Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer to 1 cell relative from named range
Try to retrieve thevalue from 1 cell relative from named range.
Something like this. Sub test() Set MyRange = Range("C1:F10") MyNumber = MyRange.Offset(1, -2).Value End Sub However the offset method gives me an array back which is not what I want. How can I retrieve the value from for example A1 or B1 or C1 with a relative reference? MyRange.Cells(1, -2) gives a runtime error. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refer to cell relative to range | Excel Discussion (Misc queries) | |||
Refer a specific cell in a named cell range | Excel Programming | |||
???Refer to a specifc cell in a named range | Excel Worksheet Functions | |||
How does one refer to the n-1 element of a named range? | Excel Discussion (Misc queries) | |||
How do you refer to a dynamic named range? | Excel Programming |