Setting .PrintRange using 2 variables

[ShaunD30]

Ok..Not sure what I am doing wrong here. Anyone?

Startadd= $A$2
Endadd= $G$40

ActiveSheet.PageSetup.PrintArea = ?? "nothing I try works here"

I thought this would be pretty simple..but when i get to the printarea part, it doesn't accept my variables.

Shaun

 

[Yard]

Dim Startadd As String, Endadd As String
Startadd = "$A$2"
Endadd = "$G$40"
ActiveSheet.PageSetup.PrintArea = Startadd & ":" & Endadd

 

[ShaunD30]

Works great! Thank you!

Shaun