I have the attached code that is giving me trouble; this is part of a much larger macro. It will execute one part of the If/Then, depending on if I use an = or > sign. I want the macro to look for a worksheet called "Error Summary", there will only ever be one if it does exist, if it does not exist I want it to simply create a the Then portion.
You may want to post what you discovered so that others could benefit from it?
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ MyGear:
Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011