How can I find the column of a reference I have in a different worksheet?
For example in A1 I have ='D:\Work\[Vars.xls]Sheet1'!D$4 which makes
reference to column 4 in D:\Work\[Vars.xls]Sheet1. I would like to find that
column number without entering the address, since that might change. Or
associating it to A1 so that if I change A1 the column number would change
automatically.

Thank you,

Manuel