下标超出范围错误 - 9 [英] Subscript Out Of Range Error - 9

问题描述

我有一个关于"下标超出范围"的一般性问题。我执行宏时遇到的错误。 这个宏已经存在了一年多，并且一次为我工作。 其他人目前正在使用宏，而
也没有问题。 因此，这个宏适用于几个不同工作站上的几个不同的人，它曾经为我工作。 一个月前我确实收到了一个新的工作站。 这个宏基本上是打开一个工作簿，
将数据从它复制到另一个工作簿。 在处理多个工作表时，是否需要在Excel中调整设置/选项？ 我想也许在我之前的Excel版本中有一个设置，我在这个当前版本中没有
。 我正在使用Microsoft Office Professional Plus 2013. 谢谢！

I have a general question regarding the "Subscript Out Of Range" error that I am getting when I execute a macro.  This macro has been in place for over a year and worked for me at one time.  Others are currently using the macro and have no issues with it.  So this macro is working for several different people on several different workstations and it used to work for me.  I did receive a new workstation about a month ago.  This macro is basically opening one workbook and copying data from it into another workbook.  Is there a setting/option that needs to be adjusted in Excel when working with multiple worksheets?  I'm thinking maybe there is a setting that I had in my previous version of Excel that I do not have in this current version.  I am using Microsoft Office Professional Plus 2013.  Thank you!

推荐答案

您好，

Excel对象模型没有重大变化。很可能您正在尝试访问具有不同名称的命名范围或工作表。你尝试调试代码了吗？哪行代码会产生错误？ 

There were no breaking changes in the Excel object model. Most probably you are trying to access a named range or worksheet which has a different name. Did you try to debug the code? What line of code generates an error? 

这篇关于下标超出范围错误 - 9的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！