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
Subject: Re: $$Excel-Macros$$ Re: Create New Worksheet Template Based on Cell
Value
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
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
sorry forget to mention please change the path of template as per your
system and template name
"C:\Documents and Settings\user\Desktop\sample.xltx"
On Tue, Dec 11, 2012 at 11:31 PM, ashish koul wrote:
> Hi Laura
>
>
> *Please try this code*
>
> Private Sub Worksheet_Change(ByVal Target As
Hi Laura
*Please try this code*
Private Sub Worksheet_Change(ByVal Target As Range)
Dim wsNew As Worksheet
Dim sht As Worksheet
If Target.Cells.Count > 1 Then Exit Sub
On Error Resume Next
If Not Intersect(Target, Range("A6:A99")) Is Nothing Then
Set wsNew = Sheets(T
try this
*Private Sub Worksheet_Change(ByVal Target As Range)*
*Dim wsNew As Worksheet*
*Dim sht As Worksheet*
*If Target.Cells.Count > 1 Then Exit Sub*
* *
*On Error Resume Next*
*If Not Intersect(Target, Range("A6:A99")) Is Nothing Then*
*Set wsNew = Sheets(Target
"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:
>
>> scanningprocess.xltm
>
>
>
>
> --
> *Regards*
> * *
how many sheets u have created in "scanningprocess.xltm" template
On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich
wrote:
> scanningprocess.xltm
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think abou
Nevermind, I figured out the reason for the error.
It solves my second issue. But not the first. What do I need to modify to
make the new worksheet it creates my template "scanningprocess.xltm"
instead of a blank worksheet?
Thank you.
On Tuesday, December 11, 2012 12:18:40 PM UTC-5, Laura Ann
