Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lastrow in formula
Hi everyone. I have a summary block on the top of a worksheet. Below
that is data, which is VBA populated and therefore every time the code is run the amount of rows of data changes. How can I have a cell in my Summary section do a direct cell reference on the last row? For example, when I run the code, the last row of data is in row 45. So the summary cell wold reference C45. If the last row was on 75, the summary would reference C75. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lastrow | Excel Worksheet Functions | |||
Lastrow | Excel Worksheet Functions | |||
Using the Lastrow variable in a Count/Countif formula | Excel Programming | |||
Go to lastrow using other column's lastrow | Excel Programming | |||
Help with LastRow | Excel Programming |