View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Matt - Data Manager - Blue Ridge Telecom[_2_] Matt - Data Manager - Blue Ridge Telecom[_2_] is offline
external usenet poster
 
Posts: 9
Default Macro to move the cursor to a different cell on the same row

This should do the trick

Sub MoveToYColumn()
Dim A As Range
Set A = ActiveCell
ActiveSheet.Cells(A.Row, 25).Select
End Sub

Assign a keyboard shortcut with Alt-F8 after you have paste the above code
into a module.

Matt Chen
Blue Ridge Telecom

"Ann Wong" wrote:

I have not written any macro in visual basic at all. I would like to write a
macro with the control key (ctrl r) that allows me to move the cursor to
column Y of the same row. For example, if my cursor is on row A12, the
activation of this macro should move the cursor to Y12. If my cursor is on
row A19, then the cursor should be moved to Y19. Any help is appreciated.