If function, if a sheet is there

[cie00011]

I have this programme that copies worksheets to another workbook. every case is different.

What i have is a series of these

If Sheets("Summary_Sheet_T1_Shorter").Visable= True Then

What i would like, as this does not work if the sheet is not within the workbook is a

if Sheets ("Summary_Sheet_T1_Shorter").present then

Does this exist?

 

[venkat1926]

see chip pearson's reply in the thread

http://groups.google.com/group/micr...hether+a+sheet+exists&rnum=4#3cf6d571fceac5c2