I want to choose the print area using VBA and print them out.

I have tried this method, but it gives me an error

> 
> This formula is missing a range reference or a defined name
> 
> 
> 

```
Worksheets("Printable Version").Activate
With Sheets("Printable Version")
    ActiveSheet.PageSetup.PrintArea = .Range("A1").Value & ":" & .Range("G55").Value
End With

```