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.
|