Hi

I'm trying to use the above in two different sheets, but referencing the
same cell on these different sheets. The macro that is called is different
but it's coming back with a "Run-time error '13': Type Mismatch"

So at the moment, if the Target.Address is "$E$6" on both then it doesnt
work. If i instead change it to an unused cell on the second sheet,
"$E$100", then it works.

Is there anyway around this so that i can leave the target addresses the
same or do i need move it all down to cells that haven't already been used
and on sheet1 and hide everything in between?

cheers

Adam