Move Print Area

Hi there , I have this code that I included with my sub code but i cannot seem to get it right - all I am intending in doing is once I have copied the rows to the next available rows I want the print area to extend at the same time . The start range or cell is A1 and the code must just pick up on the last row - I do however only want the column area to be until column T or 20

is there any one that can guide me correctly

Please Login or Register  to view this content.

Hi Holger.
Welcome back.
I would change the last column line to something like this

Please Login or Register  to view this content.

or something like it. The Op wants to restrict the column count.

Hi guys, thank you for the response/s. The code does not really extend over A - T or column 20 count. it does however move down two rows but it actually misses the 3rd row - so only extends the print area with two rows and only range "A" not A to T

I have made a small change to the Range

Please Login or Register  to view this content.

it now expands from A to T but it still does not pick up the last row that well - I must note - could this be because there is no value in the last row "A" column - I included a picture to illustrate if that helps

Attachment 728907

Yes, that makes all the difference.
To attach an example file, you have to click on "Go Advanced" at the bottom right hand side and follow the suggestions.

Re: "there is no value in the last row "A" column"
Change your LastRow calculation to

Please Login or Register  to view this content.

You said you changed the 2nd line in this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

If you want to have Column T hardcoded, change the two lines into this instead.

Please Login or Register  to view this content.

thanks jolivanes , that works perfectly thank you

Glad you have it all under control.
Good luck and thanks for letting us know that you're happy with the result.