finding value for column reference within a row

[poiu]

Hello,

I have a range Range("FY2012!F8:X8"). Please could you tell me how to find the value in column "X" and ensure that if any columns are inserted between column F and X the value returned will still be correct.

Many thanks for your help,

Poiu

 

[anandvarma]

Hello,

I have a range Range("FY2012!F8:X8"). Please could you tell me how to find the value in column "X" and ensure that if any columns are inserted between column F and X the value returned will still be correct.

Many thanks for your help,

Poiu

try address formula