View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do I set up a macro that will move the cursor down one cell?

Sub downer()
ActiveCell.Offset(1, 0).Select
End Sub

Sub downer2()
ActiveCell.Offset(1, 0).Interior.ColorIndex = 3
End Sub


Gord Dibben MS Excel MVP


On Thu, 16 Nov 2006 15:52:01 -0800, gk wrote: