Hi ya

I want to activate a certain Worksheet 'Results' using a macro. Becaus
I don't know for you whether it exists yet, I want to check that wit
an If-statement and then act accordingly (create the sheet if it's no
there yet). The expression below (.Activate) doesn't work, nor di
using 'Not Sheets(...) Is Nothing' but I look for something of thi
kind as I would like to avoid a loop to check for the sheets
existence


If (Sheets("Results").Activate) Then
...
Else
Sheets.Add
ActiveSheet.Name = "Results"
End If


Any ideas are highly appreciated, cheers!

fabaliciou

--
Message posted from http://www.ExcelForum.com