How do I define a named range as my VBA range

[James thunderbolt]

Hi

I have a spreadsheet that is quite dynamic, it generates reports that are split between 3 tables of which each can range between 5 rows to 2500 rows.

I need to be able to define a point (or points) that can easily change.

I have attached the spreadsheet as an example, I need to be able to define the different named ranges (Point 1, 2, 3 and 1 to 2) in VBA - I tried

Dim Point1Num As Range
Set Point1Num = Range(Point1)

But that doesn't work - any advise would be much appreciated. Maybe I'm applying an incorrect technique.

 

[YasserKhalil]

Hi James
Just put the named range between quotation marks " " Just like that example

Sub Test()
    Dim Point1To2_Num As Range
    Set Point1To2_Num = Range("POINT1to2")
   
    MsgBox Point1To2_Num.Address
End Sub

 

[James thunderbolt]

Wow ... I feel silly


Thankyou so much for the help though !

 

[YasserKhalil]

You're welcome
Not silly .. We all learn from our faults
Regards