Hi Guys & Gals,

Why doesn't this work?

ActiveSheet.PageSetup.PrintArea = "$a$1:$z$"&CEILING(COUNTA(D3:D42)/8;1)*46

This is only one line of a macro and the problem lies in the range-defining part. I'm totally new to VB, so the problem's gotta be in the syntax...

Thanks for any feedback