Set print area from cell contents

[kgkev]

I have a cell that calculates what I want to print

B8 = ="A1:X"&Calcs!B7
This will = A1:X62 or A1:X124 .....


How do I make this field set the print area via a macro (it will be a button push rather than a event.)

 

[VoG]

Try

ActiveSheet.PageSetup.PrintArea = Range("B8").Value