Formula to set a print area. What is wrong in the code?

[amitcohen]

Hi Guys & Gals
Hope you can help..
I created a code to select range and set a print area

    Range("A8").Select
    Selection.End(xlDown).Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlUp)).Select
    [COLOR=Red]ActiveSheet.PageSetup.PrintArea = "$A$8:$I$ & range(""L3"").value"[/COLOR]

But it popsup a runtime error 1004
What is wrong in the code?

Many thanks,
Amit

 

[VoG]

Try

ActiveSheet.PageSetup.PrintArea = "$A$8:$I$" & Range("L3").Value

 

[amitcohen]

Thank you,
Problem solved!!