Record Macro not Working

[LloydFinancials]

I am in a .xlsm file not that it would matter in this case. I press "Record Macro", perform an action like select a cell, put in a vlookup, or I could hit any simple action, hit stop recording, but all that I see in the code is:

Sub Macro8()
'
' Macro8 Macro
'
'
End Sub

The body doesn't appear.

Please advise

Thanks.

 

[Joe4]

Are you performing the steps in the same Excel file as where you are creating the macro?
I have seen the behavior you describe when people have two separate sessions of Excel open, and start the recorder in one, and then jump to the workbook in the other session and perform activity there.

 

[LloydFinancials]

That may have been it. I am not sure, but I closed all my excel files, opened just the one, and now it is working. Thank you very much for the reply and support. Solved.

 

[Joe4]

You are welcome.
If you open multiple Excel files, but in the same session of Excel, it should also work.
You typically get separate sessions of Excel if you open more Excel files from Windows Explorer or, open a new session of Excel and open more files.