Hello,

I would like to select a range of cells manually and then, through a macro, I want to define the selected zone as print area in order to print it.

I don't know what's the syntax to get the "manualy" selected cells in the code.

so I would like something like

ActiveSheet.PageSetup.PrintArea = "my selected cells"

Many thanks for your help and for this forum! it's great
Johann