I cannot arrive at the correct syntax to define my selected range as the
print area:
Set prntRng = Range(Cells(1, 1), Cells(i, 12))
prntRng.Select
ActiveSheet.PageSetup.PrintArea =

Help appreciated, many thanks
Matilda