Finding problem source causing "Your formula contains an inval
To check and see if there is a worksheet change event that triggered the
message,
just right click on the worksheet tab at the bottom of the screen, then in
the pop-up menu box, click on view code. If you see code that starts with:
Private Sub Worksheet_Change()
Then that is the culprit. Otherwise, there was probably a formula in one of
the cells you deleted that referenced an external link and was triggered by
the delete event.
"Chrisso" wrote:
Scrap that!
The file just needed to be closed and re-opened. I guess Excel got
confused.
Cheers
Chrisso
|