Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

add one more* end if* at the end see below * If wsNew Is Nothing Then* * Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Target.Text * * End If* * End If* *end sub * * * On Tue, Dec 11, 2012 at 11:11 PM, Laura Ann Dietrich wrote: > Thank you! When I do that

Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

Thank you! When I do that I get the following error (I attached screenshot so you could also see the macro) On Tuesday, December 11, 2012 12:32:27 PM UTC-5, ashish wrote: > > Hi > replace

Re: $$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

Hi replace this * If wsNew Is Nothing Then Sheets.Add().Name = Target.Text* *End If* * * with below one * If wsNew Is Nothing Then* * Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Target.Text * * End If* * * Regards Ashish On Tue, Dec 11, 2012 at 1

$$Excel-Macros$$ Create New Worksheet Template Based on Cell Value

My end goal is to have new worksheet templates "scanningprocess.xltm" auto generate/name based on the values of cells on the main worksheet (A6:A99). So far I have the following macro that auto creates a new worksheet. The troubles I am having are the following: 1. It is a blank worksheet - not