Help needed to change print code

[Paul Sheppard]

I use the below code to print individual target sheets for stores

The worksheet "Targets Eire" contains a table with targets for each store (Range A3:N13, Row A is a Header Row), below this row 14 is blank and there is more data in rows 15 to 25

The worksheet "Individual Store Targets Eire" is a template, fed by the worksheet "Targets Eire" with targets for each store

How can I change the code, so that it only prints rows 4:13?

Please Login or Register  to view this content.

[jaslake]

Hi Paul

Try this

Please Login or Register  to view this content.

[Paul Sheppard]

Hi Jaslake

Thx for this info, unfortunately it did not work as it still printed a sheet for the data from rows 14 onwards

Where in my code should I place the code you provided, I put it at the end between Next I and End Sub

Thx

Paul

[jaslake]

Hi Paul

It'll probably be something like this

Please Login or Register  to view this content.

[Paul Sheppard]

Hi Jeslake

This did not work, it gave runtime error 438

Paul

[jaslake]

Hi Paul

Don't know...can't test...post your file...I'll be glad to trouble shoot.

[Paul Sheppard]

Hi jaslake

File attached as requested

Paul

Targets.xlsm

[jaslake]

Hi Paul

This works for me

Please Login or Register  to view this content.

[Paul Sheppard]

Hi Jaslake

Thanks for your help, however your code does the same as my original code, which probably means I didn't explain it very well

I've been playing around with the code and if I change this bit

Please Login or Register  to view this content.

to be

Please Login or Register  to view this content.

, it does what I want. However this piece of code is not dynamic and If I add rows will not print out everything I want.

So my question now is what code do I need to find the first blank cell in Column A after row 4, currently that would be row 14

Thanks

Paul

[jaslake]

Hi Paul

Try

Please Login or Register  to view this content.

[Paul Sheppard]

Hi jaslake

Thx, for your patience and endeavour, that works

Paul

[jaslake]

You're welcome...glad I could help.