问题描述:

I'm using a dynamic named range for 'r_clusterSchedule' using the following formulae in the Name Manager:

=OFFSET(Scheduling!$B$15,0,0,COUNTA(Scheduling!$B$15:$B$214),1)

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?

相关阅读:
Top