P prabha_friend Prabhakaran Karuppaih Local time Today, 20:47 Joined Mar 22, 2009 Messages 1,043 Aug 21, 2014 #1 If Not Sheets(Temp(0).AbsolutePosition + 1) Then Sheets.Add After:=Sheets(Sheets.Count)
Rx_ Nothing In Moderation Local time Today, 09:17 Joined Oct 22, 2009 Messages 2,795 Aug 21, 2014 #2 Provide more code leading up to this please. Is Temp(0) a variable or the name of a sheet?