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
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?
You can click File > Feedback > Send a Frown, but you won't get a reply...