Hi Guys
I need help printing to PDF a set of data that goes from column B to J. The data start on B1 and goes down to J?. The data changes every time I run this report so the last row is always different (the report could have 4 rows or it could have 1000 rows, I never know). The code below is what I'm suing to print to PDF but it prints the entire active sheet. I only want to print the data on the sheet and leave everything blank after the data is over. Could someone please help me with this. Thank you
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="CHP.pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
I need help printing to PDF a set of data that goes from column B to J. The data start on B1 and goes down to J?. The data changes every time I run this report so the last row is always different (the report could have 4 rows or it could have 1000 rows, I never know). The code below is what I'm suing to print to PDF but it prints the entire active sheet. I only want to print the data on the sheet and leave everything blank after the data is over. Could someone please help me with this. Thank you
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="CHP.pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True