- #1
IrinaK.
- 33
- 0
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!