I fear this is so simple that I'm embarrassing myself by asking... but is there a way to copy and past combo box form controls keeping the input range static but the cell link relative in Excel 2007?

I've tried all my usual methods, but all seem to paste a combo box with absolute ranges and cell links. That wouldn't be so bad, except the form I'm creating has 210 combo boxes. Half use one input range. Half use the other. All obviously have their own individual cell link. I'd really like to avoid right clicking and choosing format control 210 times, and I can't seem to create a macro that works.

Any help would be greatly appreciated.

Thanks!