Home > Software engineering >  VBA debugging "runtime error 1004 and specified values beyond the scope of". This how to s
VBA debugging "runtime error 1004 and specified values beyond the scope of". This how to s

Time:09-17

CodePudding user response:

I test in the MS Office 2007 32-bit version, the execution result is normal,

CodePudding user response:

First point debug button, the cursor will stop error in the statement,

At this point can be used in the immediate window
? The variable name
Or
? The function name () function parameter
Or
Process (parameters)
Auxiliary debugging,

CodePudding user response:

CodePudding user response:

400 there are more than 10, 400, 200 this a few values range

CodePudding user response:

reference 4 floor caozhy response:
400 10, 400, 200 the several is worth more than the range

Do you think this a few values will be "beyond the scope of"?

And the fourth parameter, the original poster is not 200; Even 200 should be legal values,

CodePudding user response:

Don't know if "object" outnumber range cause ah,


However, I think a table inserted into the thousands, tens of thousands of this object should be no problem...

CodePudding user response:

This does not necessarily, more than range is not to say that is too big or too small, may also be illegal

CodePudding user response:

refer to 7th floor caozhy response:
this is not necessarily, beyond the scope is not to say that is too large or too small, may also be illegal



You're so empty...

The four parameters: the top left corner x coordinates, the upper left corner y, width, height
Against you this sentence, how to understand the "scope"?

CodePudding user response:

That should, on the sheet3 can add shape
Can you add in the location, the size,
  •  Tags:  
  • VBA
  • Related