John,
You will need to set the print range and then use the printout method to
print the worksheet. Here is an example:

Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$E$25"
Worksheets("Sheet1").PrintOut

Note: There are a lot of print settings that can be changed using VBA. I
recommend recording a macro and then going and looking at the code that is
generated for ideas.

Dan

"John" wrote:

I'm trying to create a button attached to a Macro that will print a constant
range of cells for a header, and several variable ranges depending on the
value of a particular cell in each variable range, and a selection of a
constant range for a footer.

PROBLEM, I have read the VBA for dummies and well, its not the right book or
I'm REALLY a dummy cause I cant figure out what I should be doing.

Any thoughts on the code I need? Or point me in the right direction??

Thanks,
John