I am trying to create a macro that sets a dynamic print area. There is a defined number of columns but an undefined number of rows. The print area should find the row with the last data point between a range of columns. I've attached a file to show what I mean. The columns that will have data (numbers and text) are C to K. In the file, the last data point is in D46, so the print area should be A1:K46.
How can I create a macro that sets the print area from A1 to K(?), where (?) is the last row with data in the columns C to K?
I'm no VBA expert but this would be very helpful. Any thoughts?
Thanks