Mar 31 2021 11:30 AM
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 something wrong with my settings. The image is attached below.
Please help me out.
Mar 31 2021 12:08 PM
Mar 31 2021 07:52 PM
Apr 01 2021 02:26 AM
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!
Apr 01 2021 02:34 AM
@Hans Vogelaar 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
Apr 01 2021 02:53 AM
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...
Apr 01 2021 02:56 AM
Apr 01 2021 03:49 AM
You can click File > Feedback > Send a Frown, but you won't get a reply...
Apr 01 2021 12:38 PM
SolutionApr 01 2021 12:38 PM
Solution