I need a macro to allow a user to go to the end of a list of data.
The list is in a named range "TypeofConcern"
So far I've got:
Application.Goto Reference:="TypeofConcern"
Set LastCell = [AA65536].End(xlUp)
SelectCell
End Sub
This just selects the entire named range - and I want the user to be taken to the first blank cell at the end of the list.
Anyone tell me what's missing?
Cheers.
Nobby
The list is in a named range "TypeofConcern"
So far I've got:
Application.Goto Reference:="TypeofConcern"
Set LastCell = [AA65536].End(xlUp)
SelectCell
End Sub
This just selects the entire named range - and I want the user to be taken to the first blank cell at the end of the list.
Anyone tell me what's missing?
Cheers.
Nobby