View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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