Hello, for thread "Macro problem for absolute reference", after I use your formula, it seems not ok. It still return #value, is there other formula? Thanks, if you give me reply, I appreciate your help.