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