name of range from macro

[Guest]

I have command:
ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:="='mySheet'!R2C1:R20C8"
but the row 20 is changeable. How could I modify the command?
Thanks.

 

[Norman Jones]

Hi Miroslav,

Try:

Sub Tester()
Dim rw As Long

rw = 20

ActiveWorkbook.Names.Add Name:="myName", _
RefersToR1C1:="='mySheet'!R2C1:R" & rw & "C8"
End Sub

 

[Guest]

Hi Norman,
thank you very much an advise. It works.
Regards,
Miroslav

„Norman Jones" napísal (napísala):