Thanks Barry, thats an interesting idea.
I have a direct link to each cell on a second sheet at present but I will give your more elegant idea a go, it saves global search & replaces :) - once I have solved my immediate problem that is.
All my spreadsheet works except ONE coloumn. The links & formula are all invisible except for the one coloumn where all I can see is '=Sheet1_2.F43' etc as the coloumn decends.
I have checked tools>option>spreadsheet>view & formula display is off.
I have checked format cells, nothing abnormal, just text like other working coloumns
Any ideas
Dave
Deleting cells & reprogramming sorted it :)
Dave
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
