Tom, in my Code, i am Hiding the Cells i dont want the user to see when the
open up the sheet.

that Column does have a Space or empty row from the main body of the sheet.

if i set the print area osheet.pagesetup.printarea = "$A$1:I$166" then i
will print out all i need with EXCEPTIONS.
1) if after i create the Data using VFP and paste it into the sheet and it
runs past "
i166" it will not print out anything under that.

90% of the time that set printarea will work.

if i remove the printarea, even though i have hidden cells, they still
printout (one column of data on the last set of pages).

i am having a problem understanding the currentregion and usedrange props
and how i will use them in VFP without a good reference.

i dont mean to act stupid, i have just hit the WALL

Tom