View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Cursor movement in a macro

Sub moveup()
Selection.Offset(-7, 0).Select
End Sub

--
Gary's Student


"Kanga" wrote:

This is really basic but I could not find a thread. I want to control the
movement of the cursor. Instead of moving up 7 cells, the macro records the
cell it ends up in. How do I get the macro to just go up a specific number
of cells.

Thanks, Kanga