Without looking a the results and writing the code to avoid duplicating them,
I doubt there is any foolproof way to do it.

--
Regards,
Tom Ogilvy


"ritu" wrote:

THANKS TOM ,THIS IS WHAT I AM DOING , I AM LOOKING FOR A METHOD IF
THERE IS A WAY , WHERE I CAN HAVE MACRO RUN JUST ONE INSTNACE AND IN
ANY OTHER CASE IT SHUD NOT RUN. THE MACRO.