I'm using a dynamic named range for 'r_clusterSchedule' using the following formulae in the Name Manager:
I then refer to this dynamic named range in VBA as
AClusterSchedule = Range("r_clusterSchedule")
I then get a Run-time error 1004. Method 'Range of Object'_Global' failed.
Any ideas on using dynamic named ranges (Name Manager with Offset formula) with Excel VBA?