阅读背景:

为什么我的错误处理程序只能运行一次?

来源:互联网 

I'm attempting to cycle through all the worksheets in a specific workbook and attempting to copy formatting from one worksheet to another. The objective here is to find the corresponding worksheet, which has the same name but is appended by "(FF)". Then I want to copy that Sheet's format to the sheet that doesn't contain the appended version of "(FF)". Unfortunately, not all sheets contain it's corresponding sheet with the appended "(FF)". That being said, I've written the Macro below to help me blow through any "Subscript out of range" errors by way of sending it to an Error Handler. The problem is, when testing this out on a workbook where no sheet has a corresponding sheet appended by "(FF)" it only blows through the first "Subscript out of range" error and that's it.I'm attempting to cycle through all the workshe




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: