Excel VBA help

[Ads Patz]

Hi All,

Everytime I record a Macro for some reason the first action is Delete. = even though i did not press delete while recording macro. This is is causing issues when I try to re run the macro. Can someone please why this happens?

Sub Macro2()
'
' Macro2 Macro
'


'
Delete. = "Hello"
ActiveCell.Offset(3, 0).Range("A1").Visible
End Sub

 

[Ads Patz]

Sub AdsMacro()
'
' AdsMacro Macro
'


'
ActiveCell.Offset(4, -8).Range("A1").Visible
Delete. = "zcfgnzf"
ActiveCell.Offset(5, 0).Range("A1").Visible
End Sub

That is the new macro i tried

 

[Fluff]

Are you using Excel's built-in macro recorder, or a third party one?

 

[Joe4]

When you go to Record the macro, it should list three options in that menu:
"View Macros"
"Record Macro..."
"Use Relative References"

Try selecting the "Use Relative References" option first, then "Record Macro...". At the very least, that should stop all those "ActiveCell.Offset..." commands.
I don't think it will affect the "Delete." statement, but cannot be sure. So we should probably test it out. That "Delete." is not even valid syntax, so I am not sure what would be doing that, other than a virus or some sort of Add-In...

You may want to go to File -> Options -> Add-Ins and view the Add-Ins that are showing as Active.

 

[Ads Patz]

Are you using Excel's built-in macro recorder, or a third party one?

The excel one

 

[Ads Patz]

Should there be an add ons enables as I do not have any active Application add ins enabled.

 

[Joe4]

I have the following Active/Enabled:

Analysis ToolPak
Analysis ToolPak - VBA
Send to Bluetooth
Solver Add-In
WebEx Productivity Tools

If you do not have any active, then that rules out any Add-In interference.

It is concerning to me that a "Delete" command is showing up in your Recorded Macro if you are not actually deleting anything.
I would highly recommend doing a Virus Scan on your computer, as it could be a virus infection.

 

[Ads Patz]

Just ran a full virus scan and no threats have been detected.

 

[Joe4]

I am at a loss then. Something clearly appears to be interfering with your Macro Recorder.
Other than other VBA code, an Add-In, or a Virus, I have no idea what that might be.