Thread: End of Column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default End of Column
hi,
try this
Sub findendcol()
Dim c As Long
c = Cells(Rows.Count, "B").End(xlUp).Row
MsgBox c
End Sub

regards
FSt1

"Philosophaie" wrote:

How do you take a column, find the last entry in it and list the row # of the
last entry?
Reply With QuoteReply With Quote