Excel 2016 Macro Recorder not working

0

Hi guys,

Please help. I am new in VBA macro. I am using Excel 2016. I have learned how to work with the VBA environment, and learned to copy codes.

I have learned to copy paste macros, and it works perfectly.

My problem is recording macros. Whenever I try recording even a very simple macro, it can't be recorded correctly. It always has a debugging problem.

Even the simplest task of just writing a simple text like "Title" in cell A1 yields debugging problems. 

For instance, I will just record "Test" in cell A1. When I try to run the code, it doesn't record properly. I looked at the code and there are unnecessary codes that go with it, as shown below:

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+A
'
    .Rotation = "This is a test"

End Sub

I don't why there are introduced as parts of the code like .Rotation and other things. At other times, there will be the presence of "Delete" codes.

I have tried doing a lot of things:
1) I tried closing the workbook and opening a new one - IT doesn't work.
2) I tried saving it as personal macro wrokbook - It doesn't work.

3) Tried recording the macro WITH and WITHOUT shortcuts - Both didn't work.

I do want to learn more about macros. But a simple task as this, and it doesn't work makes me feel disappointed. I will appreciate any help please.

Bob

Post Edited
CODE Tags: You must add [CODE][/CODE] tags around your code! (click the CODE button to do this when creating a post)
Answer
Discuss

Discussion

The macro you published above is definitely not one that should have been created by the macro recorder, presuming that you published it complete, unabridged and unaltered. I suggest to uninstall Excel, run a complete virus scan on your computer and the re-install Excel.
This is a simple macro recorded (not using any keyboard shortcuts!).
Sub Macro1()
'
' Macro1 Macro
'
'
    Range("A1").Select
    ActiveCell.FormulaR1C1 = "This is a test"
    Range("A2").Select
End Sub
 
Variatus (rep: 1815) Nov 12, '17 at 4:17 am
I have never seen .Rotation appear like that. I believe it is supposed to deal with shapes and degrees and not text! So yea, Houston, we have a problem.
don (rep: 1482) Nov 12, '17 at 10:17 am
Did you ever figure out the issue?
don (rep: 1482) Nov 15, '17 at 6:59 am
Hi Don. Unfortunately, No, I haven't figured out the answer to my question. I keep on trying each day, hoping against hope that something magical will happen and the macro recorder will work. I really do hope I am able to find an answer to this puzzle. 
baybobjr Nov 15, '17 at 12:31 pm
Worst case, you can always check out our tutorials on Macros and learn how to make them yourself. It will take more time now but save you a lot of time in the future.
don (rep: 1482) Nov 17, '17 at 3:36 am
Add to Discussion

Answers

0

Think about it logically.

  • Exel doesn't work properly
  • There are three components involved in this:-
    1) The Workbook
    2) The Excel application
    3) Your computer
  • You have already tried using a new workbook. Therefore the problem isn't from the workbook.
  • Repair Excel
    From the Control Panel select Programs -> Uninstall
    Right-click on MS Office [2013], select "Change"
    In the dialog box select the radio button for "Repair" and "continue"
    Make sure that you have only one version of MS Office installed.
    To be 100% sure, you might uninstall the program, shut down, restart
    and install again.
  • If this doesn't cure the problem you have excluded "Workbook" and "Excel"
    Therefore the problem must be with the computer.
    Most likely, you might have caught a virus: run a virus scan.
    But the cause might be other programs you have: look for anything that isn't standard fare (illegal software or unsigned software)

Basically, if it isn't the workbook, and it isn't Excel, and it isn't a virus you might wipe your computer completely and reinstall everything. Good luck!

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login