the variable "m" than the function
above, but every time I try to adjust it, I get an error message.
- The COUNT needs to be performed on the "PALMS" worksheet (however, the
PALMS worksheet is where the command button will be located, so,
technically, that will be th
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
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(
"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
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 UT
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
complexity
- I dont have the time or patience to copy each one in manually!
Any other ideas?
With regards to format of the "nasty" excel sheet, it is a HTML file
converted into excel. Does that help?
Kind Regards
Laura
--~--~-~--~~~---~--~~
Visit t
its just a text box and not a cell value).
b) Link my completed charts and tables to powerpoint quickly and
easily, without having to copy and paste each one in.
Any help appreciated - i hope this makes sense to some one out there!!
Kind Rega