Using the code below, the worksheets save to PDF and my destined file without a problem. But once I open my sheets in PDF some of the textual colours and columns are cut out and there is blotches of white is some of the cells. All in all, it doesn't look like the page in EXCEL as it does when I save it to PDF.
[hope this makes sense]

help would be awesome,

thanks,

Sheets("Zone A").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, fileName:="s:\Communities\Monthly\Zone A\Zone A.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False