Getting error invalid or unqualified reference

Hi,
I am getting error invalid or unqualified reference. If I copy-paste special-value then the superscript macro in the sheet module didn’t work. So I want to change the formula into value but I am getting error.
The code is:

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you.

Please Login or Register  to view this content.

Regards, TMS

Hi TMS,
Thank you. It's working fine but still I'm not getting correct output of superscript red code from sheet module.

Please see the file and solve the problem.

Thanking you.

Strictly speaking, the superscript issue is a different problem. However, the reason it is not working, I think, is because the formula is put into multiple cells. Hence, it seems to me that you can't use the Worksheet Change event handler to format the cells in this instance. The WSC event handler will work if you manually type, for example, 9+10, in a cell which will give you 9⁺¹⁰

Anyway, the following code seems to do the job:

Please Login or Register  to view this content.

See the updated example workbook.


Regards, TMS

Hi TMS,
Excellent! It's working fine. You have done a great job.

I appreciate you for your kind cooperation to complete my job.

Thank you.

You're welcome. Thanks for the rep.

Hi TMS,
There are headings of columns in row 7 which I don't want to superscript. So I want the code work from row 8. To achieve it I want to insert the code line in the code. I'm confused where to insert the code line to achieve the target. Please tell me where to insert the code line in the code.

The code line is:

Please Login or Register  to view this content.

Thank you and sorry for trouble.

So I want the code work from row 8.

The code does work from row 8.

Neither the code that I provided, nor your WSC event handler affect row 7.

I'm guessing it's just the residual effect of earlier formatting. If you just re-type what you want in row 7 it shouldn't superscript it.

Regards, TMS

Hi TMS,
Sorry for asking the problem here in solved thread again. The problem is related to this thread so I am posting my problem here.

The superscript problem is solved but I am not getting the correct output in total columns. I am getting output of total column 'I' in other total columns. I am not understanding why it is happening.

Please see the attachment and give me your valuable guidance to solve this problem.

Thanking you in anticipation.

OK, try it this way:

Please Login or Register  to view this content.

Note that you have reverted to fixed ranges going down to row 100. You are not using lLR so you might as well remove the lines:

Please Login or Register  to view this content.

and:

Please Login or Register  to view this content.

Hi TMS,
Thank you. It's giving error 'variable not define'.

I didn't understand the suggestion in post 11. Please guide me.

Thanking you.

In the line of code that starts with

Please Login or Register  to view this content.

... you have "& lLR" at the end. Take it out (as I have done)


Don't worry about post #11. It won't hurt if you leave it as is; you're just not using it. No big deal.

Regards, TMS

Hi TMS,
Thank you.

Sorry for not understanding your suggestion due to my poor knowledge of vba.

I'm getting error 'variable not define' on the line

Please Login or Register  to view this content.

on the word 'cell'.

Please see the macro 'multifunction' for your reference. I have added your new code in it.

Please do the necessary corrections in the macro 'multifunction' and if possible do send me the modified final copy of workbook.

Sorry for trouble.

Thanking you in anticipation.

Example updated ...

Hi TMS,
Thank you. The problem is solved. If we use 'option explicit' then the problem of 'variable not define' occures.

Just for knowledge I want to know the best approach to run the various macros one by one?

1. Integrate the macros in a single macro as we use in the example.
2. Use call event in this work module and call different macros one by one.

Thank you very much for your kind cooperation to solve my problems.

Looking to receive such a valuable guidance in future.

Thank you and have a nice day.