Hence you've found one of the largest limitations of the macro recorder. Everything in there is by activating *hardcoded* cells/references. I bet you, that if you posted an example spreadsheet, along with what you wanted done, you'd have some very efficient code to use/study.