| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing range name in calculation
I have the following three lines of code:
Dim a As Single a = Worksheets(Sheet1Name).Cells(Sheet1RowPointer, h).Value a = Round(a * (1 + WorksheetFunction.VLookup(Cells(Sheet1RowPointer, _ Sheet1RespCodeColPointer), "OverheadLookup", 2)), 0) I'm trying to perform a lookup using the range name "OverheadLookup" but I get an error message when line 3 executes. Any help would be greatly appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Referencing a Range | Excel Programming | |||
| Referencing same cell in calculation | Excel Programming | |||
| range referencing | Excel Programming | |||
| range.calculation with UDF not working when calculation is set to automatic | Excel Programming | |||
Threaded Mode
