VB for Loop & Printing

[ntowne]

I'm looking to create a macro that will take a value from a list (located on a separate sheet in the same workbook) and populate it into a cell on the active sheet, print the active sheet, then loop to take the next value off the list, populate on the active sheet, print, etc. until the macro prints sheets with all values from the list.

I am sure this is possible but my VB/Macro knowledge is pretty basic.

Any advice pointers??

[teylyn]

note: I changed the title on this thread, because thread titles ending with the word "print" will not appear in the regular forum interface.

[parrynz]

Hi, try this and amend sheet/cell references as needed...

Please Login or Register  to view this content.