I want to do the following .. any suggestions


I want to return the same value into one cell lets say cell A1
and I want it to loop through a range of values B1:B55

So it would place value from B1 into A1 performa print job, then go to B2 place into A1 perform a print job, then B3 and so on.

I know it s simple loop but can not figure it out. Any help much appreciated



Here is what I was trying


Do

ActiveCell.Offset(1, 0).Select

Loop Until IsEmpty(ActiveCell.Offset(0, 1))

End Sub