rom Vodafone
> ------
> *From: * Laura Ann Dietrich
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 11 Dec 2012 13:09:35 -0500
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based
> on Cell Va
Thanks. When I try that code (with the corrected file path), it no longer
creates a new worksheet or names one. It just points me to a random cell on
the last worksheet.
On Tue, Dec 11, 2012 at 1:03 PM, ashish koul wrote:
> sorry forget to mention please change the path of template as per your
"scanningprocess.xltm" is one worksheet.
On Tue, Dec 11, 2012 at 12:47 PM, ashish koul wrote:
> how many sheets u have created in "scanningprocess.xltm" template
>
>
>
>
>
>
> On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich > wrote:
&g
C-5, Laura Ann Dietrich wrote:
>
> 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
> trouble
et.Text
> *
> * End If*
> *
> *
> Regards
> Ashish
>
>
> On Tue, Dec 11, 2012 at 10:48 PM, Laura Ann Dietrich
>
> > wrote:
>
>> *Private Sub Worksheet_Change(ByVal Target As Range)*
>> *Dim wsNew As Worksheet*
>> *If Target.Cells.Coun
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
