Changing just one cell each time I print

  • Thread starter Thread starter kdeal
  • Start date Start date
K

kdeal

I am using Excel 2000. I need to print one sheet multiple times and
change one cell on that sheet each time it prints.

Example:

I need to print my sheet 50 times, cells J1.J50 contain a list of
numbers 001,002,003,123,456 etc. (This column does not print)

I need to copy cell J1 into cell A1 - then print my worksheet,
Then I need to copy cell J2 into cell A1 and print the worksheet,
Then I need to copy cell J3 into cell A1 and print the worksheet
You get the idea. Each time I print the worksheet I need a different
number in cell A1 because I am using VLOOKUP to fill in cells in the
worksheet.

I can write a macro using copy and paste to move the numbers one at a
time, but that is a lot of work. - There has to be a better way.

Thanks, KDeal
 
Try this

Sub test()
Dim cell As Range
For Each cell In Range("J1:J50")
Range("a1").Value = cell.Value
ActiveSheet.PrintOut
Next cell
End Sub
 
Thanks Ron,

I've only been on this forum about an hour and already have an answer
to a problem that's been bugging me for days.

Thanks again, Kirk
 
Back
Top