Bruce

I thought that VBA would be used in this. The only problem is that I
can't ge tit to work.

My workbook consists of seven worksheets with the first six all
searching for data from the seventh e.g. a cell in the first sheet may
read =sheet7!H32.

The active area is A1:DM112 - is it this range I insert into the
following

If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then

If it is I have tried it all without success - I did notice that Me in
Me.Range above is blue in your code whereas in mine its black - will
this have anything to do with it?

Thanks for the help

Dave


--
GoldDave
------------------------------------------------------------------------
GoldDave's Profile: http://www.excelforum.com/member.php...o&userid=27750
View this thread: http://www.excelforum.com/showthread...hreadid=472580