Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a variable to a range statement
Please could you tell me the correct syntax to use in this bit of code where
I am trying to define a named range "Jobs" which is A1 to row number NoOfRows. A macro recorded this bit of code below and I am trying to replace the "R360" with something like RNoOf Rows. R&NoOfRows does not work. ActiveWorkbook.Names.Add Name:="Jobs", RefersToR1C1:="=sheet1!R1C1:R360C1" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a variable to a range statement
One way
Sub test() Dim NoOfRows As Long NoOfRows = 10 Range("a1:a" & NoOfRows).Name = "Jobs" End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Mervyn Thomas" wrote in message ... Please could you tell me the correct syntax to use in this bit of code where I am trying to define a named range "Jobs" which is A1 to row number NoOfRows. A macro recorded this bit of code below and I am trying to replace the "R360" with something like RNoOf Rows. R&NoOfRows does not work. ActiveWorkbook.Names.Add Name:="Jobs", RefersToR1C1:="=sheet1!R1C1:R360C1" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a variable to a range statement
Place the Sheet name also in the code
-- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Ron de Bruin" wrote in message ... One way Sub test() Dim NoOfRows As Long NoOfRows = 10 Range("a1:a" & NoOfRows).Name = "Jobs" End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Mervyn Thomas" wrote in message ... Please could you tell me the correct syntax to use in this bit of code where I am trying to define a named range "Jobs" which is A1 to row number NoOfRows. A macro recorded this bit of code below and I am trying to replace the "R360" with something like RNoOf Rows. R&NoOfRows does not work. ActiveWorkbook.Names.Add Name:="Jobs", RefersToR1C1:="=sheet1!R1C1:R360C1" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a variable to a range statement
Try
ActiveWorkbook.Names.Add Name:="Jobs", RefersToR1C1:="=sheet1!R1C1:R" & NoOfRows & "C1" Steve "Mervyn Thomas" wrote in message ... Please could you tell me the correct syntax to use in this bit of code where I am trying to define a named range "Jobs" which is A1 to row number NoOfRows. A macro recorded this bit of code below and I am trying to replace the "R360" with something like RNoOf Rows. R&NoOfRows does not work. ActiveWorkbook.Names.Add Name:="Jobs", RefersToR1C1:="=sheet1!R1C1:R360C1" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing string as array variable (Pivot VBA) | Excel Discussion (Misc queries) | |||
Passing Variable Number of Arguments to a Sub | Excel Discussion (Misc queries) | |||
Passing Variable to LINEST | Excel Worksheet Functions | |||
UserForm not passing Boolean variable | Excel Programming | |||
Passing a value to a variable from Userform | Excel Programming |