VBA - Move Cell Down

H

halper

I am trying to write the VBA code to move down one cell and then print
a sheet. This is what I have so far but it code keeps failing. Any
help would be appreciated.

Sub MoveCell()
ActiveCell.FormulaR1C1 = "R[1]C[1]"
For i = 2 to 47
Range(Column("H"),Row(i).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Next i
End Sub

As you can see I wan to keep the cell linked to Column H, but just
start at H2 and then move to H3, and so on.

Thanks,
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top