proper syntax in code needed
I need to use something like this in my code:
Activesheet.PageSetup.PrintArea = "$A$1:$C$5"
but I need to substitute the address range above to or as follows:
Where I already have a variable "Lrow" = 7122
I wish to print the area:
A7082 (<< this # set to Lrow minus 40) : H7122
I can't get syntax to work - I've tried:
PrtRng = Range("A & LRow - 45 & ":I" & LRow) << Not being accepted
Tks in Advance for helping,,
|