Set print area and save as pdf

**Jean-Felix** · 07-10-2018, 07:06 PM

Hi guys,

I would like to have a command button to do the following command:

1. Check on sheet "FM017" the following cells for value 0 and 1:
AK31
AK53
AK84
AK106
AK137
AK157
AK190
AK212
AK243
AK265
AK296
AK318
AK349
AK371
AK402
AK424
AK455
AK477
AK508
AK530

2. Set print area from A1 to "last cell with value 0" (which will be one of the listed cells)
3. Convert / Print as PDF selection A1 to "last cell with value 0"

4. Save in same folder as excel document and use same file name for the pdf as the excel document but add current date to the file name as well. - OR: just any file name like "FM017_'current date'.pdf" (4. is optional - more important is step 1-3 at the moment)

Who can solve this? Thanks heaps in advance already!

**humdingaling** · 07-10-2018, 08:21 PM

those list of cells almost form a pattern.... 22, 31,22,31,etc

except when it hits these 3
AK137
AK157
AK190

sure its not meant to be AK159?

**jolivanes** · 07-10-2018, 08:55 PM

In the meantime you could try this.
Add the remaining addresses first.

Please Login or Register  to view this content.

**humdingaling** · 07-10-2018, 09:06 PM

awww....too slow again
anyways since i made it ...heres what i came up with if the aforementioned pattern is true

Please Login or Register  to view this content.

**jolivanes** · 07-10-2018, 09:20 PM

You have to change the old wbN line to this because you want the date in it and only one period before the extension.

Please Login or Register  to view this content.

@ humdingaling
Doesn't hurt to have a choice, does it?

**Jean-Felix** · 07-10-2018, 09:40 PM

Super quick responses!!

ups good eye, yes it should be AK159

Tried both scripts but both of them create a pdf of the entire worksheet without stopping where I would want them.

I'm using a simple IF function "=IF(A172=0,1,0)" and so on for the pattern.