Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
End(xlDown) function
I have the following function to return the last row number in a column of
numbers: Function LastRowNum() Application.Volatile LastRowNum = ActiveCell.End(xlDown).Row End Function Problem, I want it to return the last row number starting from the cell the function is in, not starting from the active cell. ActiveCell obviously has to come out, but what do I replace it with? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A1:B(xlDown)? | Excel Programming | |||
End(XlDown).Row - Problem if only 1 row | Excel Programming | |||
End(xlDown) not working? | Excel Discussion (Misc queries) | |||
repeated end(xldown) | Excel Programming | |||
XlDown: Go to next blank row | Excel Programming |