Navigation buttons in Excel

[wdve]

Hi Al
Is it possible in excel to create a button that will jump the user back to Column 1 NO matter where they are in a worksheet?

ALso is it possible to record a cell reference and alternatively be able to "jump" the user back again?

Thanks everyone!

 

[TonyJollans]

Doesn't the Home key take you back to column 1?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[kjv1611]

You can record a macro, then set a custom button to run the macro. When the macro is recording, (assuming you are already not on cell A1) you can select cell A1, then stop the recording. It should have all the code taken care of.

Or, if you want it in reference to the current row, you could reference that cell a few different ways, one of which would be:

Private Sub MoveToColumnA()
  Range("A" & ActiveCell.Row).Activate
End Sub

By the way, who's Al?

--

"If to err is human, then I must be some kind of human!" -Me