Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to reference a changing 'last row' cell in a formula
I've done this in a vba macro, but now I have a need to do it in a
cell formula. In my worksheet, a new row of detail is added daily. In the 'header' area (rows 1 through 10) I have a cell that needs to make a calculation based on the value of a cell in the most recently added (last occupied) detail row. In pseudo code it would be something like this: =$B(LastRow) * 23.5 Is there an elegant way to do this? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy an exact formula without changing cell reference | Excel Worksheet Functions | |||
referenceing 'last row' in a cell formula | Excel Programming | |||
Change formula file reference by changing value in cell | Excel Programming | |||
A cell reference in a formula changing | Excel Worksheet Functions | |||
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) |