I'm banging my head against a wall here... I can get this to work sometimes, but other times it gives me the 1004 error.

It will print to any printer I select, Microsoft Doc Writer, just not to Adobe .pdf....

Print Table Macro Test.xls

I've tested on Excel 2003 & 2007... I'm just trying to repeat rows at top for a non-continuous selection. Any help would be much appreciated.

Thanks!
Lance