Hi Pete,
No there is nothing in the sheet apart from the Data in A1 & A2. A1 entered
by me, A2 entered by the code.
I think that the Event Procedure is more a sort of "Worksheet_Change or
Refresh" than just a Worksheet_Change.
VBA entering the data in A2 is a Worksheet_Change so the code fires again.
On the second and subsequent runs although the data in cell is the same as
the code in entering it still fires the code again and so on..... or so says
Chip.
Did you try the code and get a different result?
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Pete_UK" wrote in message
ps.com...
Hi Sandy,
I'm certainly no expert in VBA, but could you possibly have a NOW()
function somewhere on the sheet or something similar, which is causing
it to recalculate (and therefore change) to trigger the macro?
Just a thought ...
Pete