VBA错误代码“运行时错误16，过于复杂”。 [英] VBA Error code "Run Time Error 16, Too Complex"

问题描述

运行填充的动态数组时，我试图获取元素的内容并收到以下错误运行时错误'16'：表达式过于复杂。表达式复杂吗？

When running a Dynamic array that is populated I am trying to get the contents of an element and receive the following error Run-Time Error '16': Expression too complex. The expression that is to complex?

Impactdays很长，我只是通过将范围填充到数组中来填充电子表格

Impactdays is a long, I populated the spreadsheet by simply stuffing the range into the array

ReportArray = Impact_Chart.Range("Data.EventNumber").CurrentRegion.Value

For i = LBound(ReportArray) + 1 To UBound(ReportArray)

If ReportArray(i, iImpactCol) > 0 Then
        iImpactDays = ReportArray(i, iImpactCol)<-- Tosses error here

        'more stuff

有什么主意吗？ :)
哦，这是2007年

any ideas oh gurus of everything? :) Oh this is 2007

推荐答案

检查您是否未使用

   If (Not MyArray) = -1  

程序中的某个位置。 已报告该错误与您的错误之间的联系。

somewhere in your program. It has been reported a connection between that and your error.

HTH！

这篇关于VBA错误代码“运行时错误16，过于复杂”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！