1. The problem statement, all variables and given/known data 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. 2. Relevant 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. 3. 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!