Excel 2011 for Mac Mixed Reference Macros Issues

[IrinaK.]

Homework Statement

Hello!

I would be grateful for your help. I've tried many many times to record a mixed reference macro on my mac, and it doesn't record a thing.
No problems with recording separate macros with relative or absolute reference.

Problems description:

I have few sheets with tables of the same format, but the amount of data in colums is different, thus I need a macro that would have both relative and absolute references.

Homework Equations

I do every step exactly as they have to be done, following this instruction from 10:44 to 21:48

Let me repeat: when I separately record macros with relative or absolute references, these guys work.

The Attempt at a Solution

After following all steps, I check what is being recorded (the code) and it shows this (relative nothing, no steps, no records):

Sub Macro25()
'
' Macro25 Macro
' newmacro
'
' Keyboard Shortcut: Option+Cmd+q
'
End Sub

Thank you!

 

[mfb]

You can record both versions and combine their codes properly or even write the macro from scratch if changing during recording does not work.

 

[IrinaK.]

You can record both versions and combine their codes properly or even write the macro from scratch if changing during recording does not work.

I am not sure I am that technically informed. I presume I did write the macro from scratch, just as it is shown in the video attached. The result, well no result actually. I've tried it many many times by creating different tables.

 

[mfb]

No, I mean write as in actually write, like you write text here.

 

[IrinaK.]

No, I mean write as in actually write, like you write text here.

thank you, but I am sorry, I do not understand you. did you have a chance to check the part of video I am talking about?

 

[mfb]

Yes.
You can record macros, but that just allows very basic things. If you want to do more complex things, you'll have to write the macro yourself (or at least modify existing recorded code). There are tons of tutorials how to write macros.

 

[IrinaK.]

Yes.
You can record macros, but that just allows very basic things. If you want to do more complex things, you'll have to write the macro yourself (or at least modify existing recorded code). There are tons of tutorials how to write macros.

you see, this video shows truly basic macro, and these steps work in any Excel except for my one on Mac. Shall I do something differently to make sure it works on my one too? I am not talking about profound issues; I just need to record the same thing shown in the video.