Macro updates and link goes #REF! ???
 

I (Excel 2003) have a WS(Data) containing a macro that updates a cell (stock
quote) via a toolbar button.

I have linked this cell to another WS cell (=Data!$B$1) which works fine if
I manually change the input.

However, when I run the Macro, which refreshes the data from the URL the
linked cell loses the link and I get (=Data!#REF!)

Can anyone help here please?

Thanks in advance ...

Rob Smith wrote:
when I run the Macro, which refreshes the data from the URL the
linked cell loses the link and I get (=Data!#REF!)

Can anyone help here please?


It would help if we could see the macro.
If you cut and paste to/from the cell or delete the cell then you would
get this effect.

If such an operation is inevitable then you could change the formula to
=INDIRECT("Data!$B$1")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup