Finding the last cell in a series
 

How do you find the last cell in a series i.e. in a column? I have heard that
there is a simple command that does it but I dont know what it is. Please
help me!

Finding the last cell in a series
 

Dim lastCell as Range
Dim col as Long

Col = 5
Set lastcell = Cells(rows.count,col).end(xlup)

msgbox "Last used cell in column E is " & lastcell.Address

--
Regards,
Tom Ogilvy


"Arne Hegefors" wrote:

How do you find the last cell in a series i.e. in a column? I have heard that
there is a simple command that does it but I dont know what it is. Please
help me!