Thanks for the info, unfortunately however this does not seem to work? When I go to print preview it is still trying to print the whole document? There is also now print area currently set. I assume the entire worksheet will be printed due to the formatting of all cells in the worksheet? How do I get around this, as these cells must be formatted/validated, yet I do not want to print all of the blank cells?