Printing labels from excel - VBA

[Jumparound]

Hi, I am currently battling with trying to fit 2 labels on 1 page in excel via VBA. I have code to create the labels and put them all in one worksheet but what I can't figure out is if there is a way to set the size and scale of the labels to fit the maximum size on each printed page. I can mess around with it a lot to try and get it to fit manually but then if the printer chnages it no longer fits properly. Is there a way in VBA to refer to the printer area and fit a grouped shape to match that?

 

[Trevor G]

Are you using a recognisable manufacturer's label as they would normally provide the sizes per page.

When you record a macro to adjust the measurements would that not provide the code that could help you.