Using the Cells method in VBA:

Cells(1+1,1) moves one row down.

Cells(1,1+1) moves one column to the right

Cells(2-1,1) moves one row up.

Cells( 2,2-1) moves one column to the left.

"Thames" wrote:

I want to print a serial number on previously printed gift cards. The gift
cards are printed 2-up on 8.5x11 stock. I thought I could create a 50 sheet
workbook and print 100 cards at a time by printing the workbook, using my
card stock in my printer tray. Am wondering if there is a way to reference
the cell in the preceeding worksheet, then add a +1 value.