Bit of advice please.
I posted a previous request to copy tables x times. http://www.ozgrid.com/forum/showthread.php?t=203236
Now I need to set the dynamic print area. I'm not sure how to go about it.
I know the last cell I need to reference, and it's using the following line:-
How do I write code so it prints from cell A1 to the last offset cell in the above code?