C Cele Member Jun 7, 2017 #1 Hi, I am trying to create a macro on an xlsm file. But every single time i try to assign the macro i get this error Formula is too complex to be assigned to the object. Do you know how i can fix this? Please advise. And thanks in advance. Cele
Hi, I am trying to create a macro on an xlsm file. But every single time i try to assign the macro i get this error Formula is too complex to be assigned to the object. Do you know how i can fix this? Please advise. And thanks in advance. Cele
SirJB7 Excel Rōnin Jun 7, 2017 #2 Hi, Cele! Never got such error... could you please upload the file? Regards!
Hui Excel Ninja Staff member Jun 8, 2017 #4 Can you make a sample file with the data and the formula that you are trying to replicate? Or simply post the formula here?
Can you make a sample file with the data and the formula that you are trying to replicate? Or simply post the formula here?
Hui Excel Ninja Staff member Jun 8, 2017 #5 Try removing any [ or ] characters from file names ie: Save the file with a new name not including any special characters
Try removing any [ or ] characters from file names ie: Save the file with a new name not including any special characters
N NARAYANK991 Excel Ninja Jun 8, 2017 #6 Hi , Googling this gives a lot of results ; one of them is this link : https://www.excelforum.com/excel-pr...omplex-to-be-assigned-to-object-and-quot.html Narayan
Hi , Googling this gives a lot of results ; one of them is this link : https://www.excelforum.com/excel-pr...omplex-to-be-assigned-to-object-and-quot.html Narayan
C Cele Member Jun 8, 2017 #7 Oh my! It actually worked. I had the file in a folder that started [DATA]....and when I changeD the name, and saved it in another folder it worked. Your the best. A million thanks!
Oh my! It actually worked. I had the file in a folder that started [DATA]....and when I changeD the name, and saved it in another folder it worked. Your the best. A million thanks!
SirJB7 Excel Rōnin Jun 8, 2017 #8 Hi, Cele! Surely you went thru this sometime in the past: http://chandoo.org/forum/forums/new-users-please-start-here.14/ Had gone there, you should remember this: http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705 And specifically this: "Important When Posting data online always remember to anonymise the data, especially names or data if it is commercial or confidential in nature." Regards!
Hi, Cele! Surely you went thru this sometime in the past: http://chandoo.org/forum/forums/new-users-please-start-here.14/ Had gone there, you should remember this: http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705 And specifically this: "Important When Posting data online always remember to anonymise the data, especially names or data if it is commercial or confidential in nature." Regards!