Having looked through a number of posts I am unable to find code to help. The problem is I need to select a print range on a rolling 13 week basis based on the columns. Currently the page is set up to repeat column A which contains the headings/categories on every page. I need to change which columns are also printed next to it based on which is the last column that has data in row 61. The first 13 weeks run from Col B to Col AA (each week has 2 columns), when week 14 is populated the range would need to be Col D to Col AC, reme,ber I still need to have Col A in both instances. So the range will be the last populated column -26 columns to the last populated column.
To make things more difficult if the column which is blank in row 61 is less than Col AA I still need to print Col B to Col AA and Col A.
I hope that makes sense.
To make things more difficult if the column which is blank in row 61 is less than Col AA I still need to print Col B to Col AA and Col A.
I hope that makes sense.
