View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Automating Excel (Macros)

This will move down 10 rows and insert the row number ... as an example.

Sub test()
ActiveCell.Offset(10, 0).Select
ActiveCell.Value = ActiveCell.Row
End Sub

Regards

Trevor


"Outlook Convert" wrote in
message ...
Is it possible to create a macro that will move down a certain number of
cells (for example, 10 cells) and then enter a number? Thanks in advanced.