GO TO in Excel

[Em Ratty]

I am doing a long list of books on a workeet with 5 columns. I do not want to
sort it yet, I need to go to the first empty cell on column A (A 1200), or
the last cell with info. I do not want to go down 30 or more pages to get to
it. The Edit--GoTo--Special--Last line will take to column AE. HELP! Thanks,
em

 

[Mike H]

Hi,

You could put this in a general module and assign a button to it on the
workshhet

Sub GoToLastrow()
ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Offset(1).Select
End Sub

Mike

 

[John]

Hi
Have you tried > Ctrl End <
Regards
John

 

[Mike H]

As an afterthought it may be better to allocate a shortcut

When you've installed the code in a general module then go back to the
worksheet and

Tools|Macro - Macros - Options and assign a letter. You then call it with

Ctrl+your letter

Mike

 

[Rick Rothstein]

Activate any cell in the column you want to go down in (Column A in your
case) and then press Ctrl+{DownArrow}.