Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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,, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Proper syntax for this | Excel Discussion (Misc queries) | |||
proper syntax order | Excel Worksheet Functions | |||
VBA code to sum a row: syntax needed | Excel Discussion (Misc queries) | |||
Syntax needed for With | Excel Programming | |||
Proper syntax to Set a Workbook Object? | Excel Programming |