Hi Experts,

I need your help (please!). I'm fairly new to this, so apologies fo
the dumb questions.

I'm using the same Worksheet_Change macro on several different sheets
to call a different macro, which is saved on a general module sheet.

It should be fairly simple, when a particular cell changes, then i
calls the macro.

The exact code is:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target = Range("C1") Then
Call FindSheet
End If
End Sub

The macro runs fine but if I drag and drop a completely unrelate
formula anywhere on the same sheet, I get the following error message:

Run-time error 13. Type Mismatch.

Any ideas?

Obviously, any help would be gratefully recieved!

Thanks

Dean :confused

--
deanayoun
-----------------------------------------------------------------------
deanayoung's Profile: http://www.excelforum.com/member.php...fo&userid=2493
View this thread: http://www.excelforum.com/showthread.php?threadid=38475