View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_140_] John[_140_] is offline
external usenet poster
 
Posts: 57
Default 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?