View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] erick.mckesson@gmail.com is offline
external usenet poster
 
Posts: 2
Default Jumping to a location in an excel sheet.

you can insert a module in VBA and then put a button (from the forms
toolbar) on the excel sheet....you just need to attach the macro that
you write in VBA to the button. For the code you can use something
like this:


Sub LastCell()
Range("A3").Select
ActiveCell.End(xlToRight).Select
ActiveCell.End(xlDown).Select
End Sub


---Substitute A3 for the top left cell in your spreadsheet. If you
copy this exact code into a module in VBA your macro will be called
"LastCell." Attach this to the button and you are set. If you want to
go to the first column of the last entry simply leave out the
ActiveCell.End(xlRight).Select portion of the code.

As far as your second post goes, I have no clue what you are talking
about.