D/Joel

I was waiting for notification to my email id and never got any. I took the
chance to see if any answer then I found your response and hence sorry for
the delay in ack.

Just saw ur help. will read up the links and revert. Thanks for the tips
and will try the code also n wl rvrt.
brgds/captgnvr

"joel" wrote:


Found = False
For each Sht in sheets
if Sht.Name = "report" then
Found = True
exit for
end if
next Sht

If found = False then
Sheets.Add().Name = "report"
end if


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145627

.