Printing in a loop

Robert
I think you will need to supply more details before anyone can help.
Celia

There's nothing else to it, I have information in rows that I want to transfer to a pay stub, one row at a time, print that stub and then move down to the next row, print that stub and so on.

Thanks
Robert Burge

Robert
Nothing else to it? OK, see if the following is what you need.
Select the rows that contain the data and then run the macro which will print each row one at a time.

Sub PrintEachRow()
Dim rw As Range
For Each rw In Selection.Rows
rw.PrintOut
Next
End Sub

Celia

There's nothing else to it, I have information in rows that I want to transfer to a pay stub, one row at a time, print that stub and then move down to the next row, print that stub and so on.

Thanks Celia, I'm not totally sure if this is what I'm looking for, but I'll give it a shot. I'm going to have to read the help topics to help me out along the way.

Robert