Run-Time Error

[HangMan]

How would I go about amending this code on the 'InsertRows' macro (Crtl i), so that I don't get a Run-time error '13', when the cancel button is clicked on the dialogue box?

Please Login or Register  to view this content.

Many thanks...

[Trebor76]

Hi there,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[mrice]

Try this

Please Login or Register  to view this content.

Note that J is no longer defined as Long which allows it to take a string value as well. I've added a type argument to the input box to force a number being added.

[HangMan]

Hi Trebor76,

This still gives the same error...

[HangMan]

Hi mrice,

This removes the error, however, it also inserts two blank rows above the selected cell (rather than below it as in the original), even when nothing is entered into the dialoue box?

[Trebor76]

For mrice's solution replace this line...

Please Login or Register  to view this content.

...with this:

Please Login or Register  to view this content.

As for my code I'm not sure as it worked fine for me

Robert

[mrice]

Ooopss

Please Login or Register  to view this content.

[HangMan]

Hi Trebor76

Weird, tried your code again and yes, it is all working correctly, must have been something I did! You're suggested change to mrice's code also fixed the problem.

Many thanks

[HangMan]

Hi mrice,

Trebor76' tweak fixed your code, plus your revision also works, so many thanks for your help.

[HangMan]

Hi mrice,

Trebor76' tweak fixed your code, plus your revision also works, so many thanks for your help.