Thread: Last cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hawk[_2_] hawk[_2_] is offline
external usenet poster
 
Posts: 6
Default Last cell

Trying to make a macro that will find the last cell, that can vary, in
colum J
but having trouble getting my brain around how to do it.
Any help appreciated.

Roger


Sub Macro1()
'
'
Application.Goto Reference:="R5C8"
'Selection.End(xlDown).Select
Range("A1:J68").Select
Range("J68").Activate
End Sub