Macro Error 400

[dorabajji]

Hi,
I did a macro for a client and it is working in my system excel 2010 but it is throwing up error in Office 365..
I have used specialcellsformula for selecting range.. and it is not related to any particular worksheet.. the macro runs based on selected range to convert abs to rel or vice versa for the formula..

ANyidea , what ay be the reason.. is anything to be taken care off it the macro to be used in latest versions?
any suggestions and solutions are appreciated..

[dorabajji]

i have attached the file.. mine is excel 2010 and i dont get any error.. but in 365 it is getting error.. client said error 400.. Can anyone let me knwo what is the issue in macro

[dorabajji]

Hi ,
Is there any online checking or trial testing for macro to be used in upgraded excel version?

[alansidman]

Have you looked at this site? http://www.repairmsexcel.com/blog/fi...-vba-error-400

[dorabajji]

Hi,
I have already looked that site.. But i cant tell my client that your installation is faulty or windows registry issue...
eventhough , he told me that he had upgraded recently..
I just want to be correct from my side..
Can you check my macro and tell me if there is any error..
THe catch is first he didnot get error.. but when i did some changes in the function, he told me he is getting error..
But , i dont see any error popping up in my file..

[Leith Ross]

Hello dorabajji,

I downloaded the workbook in post #2. When I opened it, there were formula errors everywhere. Most of the errors were #REF. There is no way anyone can troubleshoot the problems in this workbook without meaningful data.

[dorabajji]

Hello dorabajji,

I downloaded the workbook in post #2. When I opened it, there were formula errors everywhere. Most of the errors were #REF. There is no way anyone can troubleshoot the problems in this workbook without meaningful data.

Hi Ross,
This is due to I copied formula in excel 2010 from his file and worded upon the macro.. do u have latest excel version .. if so I will upload his file?

[dorabajji]

Hi Ross,
I am attaching the file.. but it is getting upload failed.. i dont understand what is the issue.. I tried many times to upload, but it is failing to upload...
File size is more than 6 mb? i think it is due to it..

Can i send you personally via anyother.. is it possible??

ANd in the current workbook.. i tested using R53,54..T62,66..
This macro works.. on selecting cells.. and if there is a formula it changes to absolute only for the certain sheet the name given.. for others it will be relative..
For me it works perfectly and it changes..
But the problem is when i copy the macro in his file..
IF you see #name in the file, this is what it was reflecting in his file..
THis was due to _xnif due to version downgrade.. the IFs function were replaced by this.. SO all were changed to #name.. still i checked the formula in the cell were changed..
But when i send it , he could not use it.. the same #name comes.. and so i pasted him the code and he has pasted in this.workbook instead of module..
for him he is saying error 400..
I have told him to change it to by inserting new module..
but still am curious , as to how working macro, throws error in upgraded version.. and also worried as to how this can be mitigated.

[6StringJazzer]

I am attaching the file.. but it is getting upload failed.. i dont understand what is the issue.. I tried many times to upload, but it is failing to upload...
File size is more than 6 mb?.

Size for .xlsx and .xlsm file is limited to 1MB. However, a ZIP file or .xlsb file can be up to 9.77MB. Please zip your file and upload the ZIP file.

[dorabajji]

Size for .xlsx and .xlsm file is limited to 1MB. However, a ZIP file or .xlsb file can be up to 9.77MB. Please zip your file and upload the ZIP file.

Hi zazzer,
Do u have latest excel 19/365..
As I am having 10.. and I didn't get error..only in the latest macro getting error.

[dorabajji]

still getting failed.. 5.844 mb zip

[dorabajji]

Hi All,
Since i couldnt upload the original file... This is my test file..Where i have to convert the formula reference to rel to abs.. for certain sheet..
I select range from r 50 to 56 and t60 to 67
This based on selection..
For me i dont face any issue.. But the client is telling me the macro gets him error 400.. By googling , i got to know that it may also be beyond excel..
I want to know whether my macro has any issues.. I didnot get any error and also it was smooth and changed the cells to abs for particular sheet name..

So if anybody can test , kindly check the macro in the sample file for the range i have mentioned..Kindly ignore #ref..
if anybody interested to get original file for testing.. kindly let me know any alternate means of sending the file...

[dorabajji]

kindly let me know, if you find any corruption or memory consuming code in my macro.. and if you have idea why it is misbehaving in office 365 or latest version , let me know..

[Leith Ross]

Hello dorabajji,

I don't think I can be of much help since I don't have Office 365 running on Windows 2019.

[6StringJazzer]

You will have to explain how to run your macro.

[dorabajji]

Hi Jazzer,
select cell r53 and r54 and then run the macro.. it will change to abs fr sht nme range..
others will be relative..
Whats yr excel vrsn?

[dorabajji]

Hi Ross,
Thank you for the help.. Even if you have greater than excel 2013 it would of help.. As i want to check.. If the macro can produce error in different versions..
As i have checked in 2010 and 13 .. it is going on smooth.. But am not sure.. I have only 10 and 13 thats y..

[dorabajji]

And thanks for all chipping in and trying to help me..