View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default 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,,