Forum Discussion
Solved
Macro gives compile error
Dear friends, I am new to Excel Macro. I recorded a very simple macro (typed 'a' in cell A1) and saved it for testing. When I run the macro, it gives me a compile error. I suppose there is someth...
- It looks like someone else had this issue and was able to fix it by uninstalling/reinstalling office. That would be the only thing I could suggest as you're certainly not doing anything wrong.
https://techcommunity.microsoft.com/t5/excel/excel-macro-recording-generate-wrong-vba/m-p/190857
Dear Hans,
Your code is working well. But why is my macro not being recorded correctly? I searched for a solution everywhere but this problem seems unique to me.
Please check this short video where I recorded my macro.
https://youtu.be/clYd5nc2fN0
Thanks,
Pratik
Your code is working well. But why is my macro not being recorded correctly? I searched for a solution everywhere but this problem seems unique to me.
Please check this short video where I recorded my macro.
https://youtu.be/clYd5nc2fN0
Thanks,
Pratik
As I wrote in my first reply, it's weird. The macro recorder is far from perfect, but I haven't seen it mess up completely like this. It's clearly not your fault!
HansVogelaar How do I correct this? Is there a reset option in Excel?
I got a research paper pending due to this. Any solutions helps!
Regards
You might try recording another macro to see if the same problem (or a similar one) occurs. If so, you'll have to write your macros from scratch...
- Not a single macro that I recorded is working. Guess I'll have to take the hard way of writing the code which I am clueless about. Is there a customer complaint mail id where I would get a response from MS?