VBA error

If you have an array, for example, it means the index to that array is too high or too low. If it is referring to a workbook or worksheet collection, it means that element doesn't exist (is not found).


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

We don't want an image. That's not helpful. Please read the instructions at the top of the thread in the yellow box.

Attach your workbook - nobody can help without seeing the code in situ.

Sure., but not sure about the rules/guidelines and confidentiality of posting the entire code/modules.

posting the entire code/modules.

We don't want the entire workbook. We need a small representative and anymised sample and the relevant code. Enough theat we can run the code and replicate the problem.

If it has worked for a long time, what has changed recently? Window update? Office update? Changes to the workbook? Changes on the worksheets? Or the worksheet names?

Pasting the code below,

The scenario is there is a userform and a button. I must identify from were the button is being called.

Please Login or Register  to view this content.

Please review the forum guidelines on CODE TAGS. I have added them for you this time.

Hello,
I really need a very quick help with vba.

That's not how this forum works. People volunteer their time as and when they can. Do not use PMs in this way.

You were asked for a sample file that demonstrates the problem. You haven't provided it. You haven't even identified where in the code it errors. And, without a file and instructions on how to replicate the problem, we can't help you.