I am trying to set the print area dynamically to the worksheet. I have got the code so far in the attached file. I think I am not doing something right. Please be aware that the numbers of rows will change and so will the number of columns to the right. Sometimes the last column will be P, sometimes R or Q. The print area is not expanding to the right and to the down.