Hi,

I'm not only new to this forum, but I'm new to VB. I've been reading, and trying to practice using the samples from the books, but am having some trouble. I type everything in EXACTLY the way it appears in the books and my debugger finds faults. Since I am new - I can't figure out how to fix the problems and ultimately solve my real problem which is this:

I have an Excel Spreadsheet that contains all the elements of a quote - even 2500 possible items to choose from with pricing. When you actually create your quote, you rename the file and put in quantities for the items you want. In the past, this was contained in a QuattroPro database with a macro to print the quote with ONLY the rows that had quantities entered (in column "H"). The remaining items that were not part of the quote were not printed.

So, this has been converted to Excel due to the lack of help from the Corel people for QuattroPro. Now, how does one write the macro for this in Excel? There is a "header", then the items selected and a "footer". I say Header and Footer, because they are part of the spreadsheet and you want them to print out once - not on every page.

Does this make sense? I was thinking of using an If Then statement, but since I can't seem to test out even the simplest thing in VB, I'm stuck. Am I on the right track?

Sorry this is so long,

Gabs