Forum Discussion

Copper Contributor

Mar 31, 2021

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...

Macros and VBA

JMB17
Apr 01, 2021
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

MVP

Mar 31, 2021

patilosophy

Weird! Try changing the macro to

Sub Macro1()
    Range("A1").Value = "a"
End Sub

patilosophy
Copper Contributor
Apr 01, 2021
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
- HansVogelaar
  MVP
  Apr 01, 2021
  patilosophy
  
  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!
  - patilosophy
    Copper Contributor
    Apr 01, 2021
    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