Hello all...
I'm trying to write a pretty simple macro which invokes a built-in DDE function to retrieve some data, then when the data is retrieved, just show a msgbox. When the data is finished being retrieved, cell(20,11) in the sheet "Historical Data" will automatically have "FINISHED" placed in it. So while the retrieval is taking place, I'm simply looping and checking the contents of this cell waiting for it to read "FINISHED". My problem is the
'Do While Sheets("Historical Data").Cells(20, 11) <> "FINISHED"' line generates a "Type Mismatch Runtime Error 13", which I can't for the life of me understand why. Can anyone shed any light please?
Thanks!
Shawn
Bookmarks