当前位置: 动力学知识库 > 问答 > 编程问答 >

excel - Dynamic Named Ranges and VBA error

问题描述:

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?

分享给朋友:
您可能感兴趣的文章:
随机阅读: