Excel Macro Needs Help Fast

Hello,

I'm currently trying to introduce macros in my reports at work. Everything works fine but there's one thing that I just CAN'T find an answer to. Actually, I'm using the OFFSET function to copy/paste formulas to a specific column (let's say column C) but the problem is that if, someday, someone has to add a column in the sheet. My column C might become column D and the macro won't work.. how can I "Name" that C Column (let's say I name it "Base") so that it will always offset to the column named "Base"?

Any help will be greatly appreciated!

Thx

Max