Sorry gentlemen,
i have some kind of printing problem.... actually i have a dozen of sheets that belong to the same workbook, the first has a little button that prints the full set of pages in a single pdf. But this is less improtant. the tricky part is that every sheet of the set is already having a proper layout to be printed in A4 pages, in order to be compliant with most of the free dpf virtual printers.
Now, according to the fact that some sheets can have more data than what being able to be printed in one single page, i have arranged multiple entries of the same layout inside that sheet (one after the other vertically) and trigger the number of pages to print with an inline formula inside the property "PrintArea".
The formula i use is quite similar to the one written here
=$A$1:index($P:$P,match("ZZZ",$R:$R,1))
even not exactly the same.
The problems is the now the follwing.
When i set this formula on theet no. 3 for example, it works and if i increase or decrease data on the page, it automatically matches the right amount of pages to print of that kind of sheet.
I do the same then on the sheet number four, or another one, it is not important, and it works too, but loses the setting on sheet 3! -.
That's unbelievable! Most umbelieavle is that is sometimes resist to the change and sometimes it loses the setting.. it is also not constant error!
The PrintArea property is a locale variable for each sheet and it is not a "static" variable of the entire workbook: this would mean that every sheet should be allowed to have different setting and check out what to print according to the value of the variable PrintArea belonging to that sheets itself.

What am I doing wrong=.... i'm getting annoyed now... it's more than one week trying to work this out....
please help me...!

tks a lot

Alex