1 wrote:
>> >
>> > Attach your final result for comments
>> >
>> >
>> > Don Guillett
>> > SalesAid Software
>> > dguil...@gmail.com
>> > -Original Message-
>> > From: Susan 1
>> > Sent: Wednesday,
Message-
> From: Susan 1
> Sent: Wednesday, December 07, 2011 6:14 PM
> To: excel-...@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in
> one
> workbook
>
> So your macro works, but it is for 365 days, and now I have 365
> shee
Hi
in Noorain's code, i would make the following change to the line that
starts the same:
Sheet1.UsedRange.Copy Sheets(Sheets.Count).Range("A1")
then delete sheets created with sheet names from dates in sheet1 and
it should work
Don's code is more straightforward, something new I have to learn to
aw,gee...
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Susan 1
Sent: Wednesday, December 07, 2011 11:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one
workbook
Great Macro Don! Very helpful for my task... I
December 07, 2011 6:14 PM
>
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in
> one workbook
>
> So your macro works, but it is for 365 days, and now I have 365
> sheets, I needed the sheets to be named according t
-
From: Susan 1
Sent: Wednesday, December 07, 2011 6:14 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one
workbook
So your macro works, but it is for 365 days, and now I have 365
sheets, I needed the sheets to be named according to
tware
dguille...@gmail.com
From: Susan 1
Sent: Wednesday, December 07, 2011 2:10 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in
one
workbook
I copied and pasted your code from below in a blank spreadsheet and when I
run it I receive
t; SalesAid Software
> dguille...@gmail.com
>
> From: Susan 1
> Sent: Wednesday, December 07, 2011 2:10 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one
> workbook
>
> I copied and pasted your code from b
$$ Formula or macro to add names to sheets in one
workbook
I copied and pasted your code from below in a blank spreadsheet and when I run
it I received the following error: Script out of range.
Please advise.
Thanks!
On Wed, Dec 7, 2011 at 7:04 AM, dguillett1 wrote:
This macro will copy the
I copied and pasted your code from below in a blank spreadsheet and when I
run it I received the following error: Script out of range.
Please advise.
Thanks![?]
On Wed, Dec 7, 2011 at 7:04 AM, dguillett1 wrote:
> This macro will copy the template and name each sheet with the start of
> the w
Hi Noorain,
The macro only worked for the first sheet, after I run it again I receive
this error #: 1004
Sheets(Sheets.Count).Name = Sheet18.Cells(i, "A").Value
On Tue, Dec 6, 2011 at 8:09 PM, NOORAIN ANSARI wrote:
> Dear Susan,
>
> Please try it and see attached sheet.
>
This macro will copy the template and name each sheet with the start of the
week (short names better)
If you want the first MONDAY then change ,7 to ,8
Option Explicit
Sub addsheets()
Dim i As Long
For i = Day(DateSerial(Year(Date), 1, 7) - _
WeekDay(DateSerial(Year(Date), 1, 6))) To 365 Step 7
Sh
Dear Susan,
Please try it and see attached sheet.
Sub Sheet_Creater()
Application.ScreenUpdating = False
Dim i, j, k As Integer
j = Sheet18.Cells(Rows.Count, "A").End(xlUp).Row
For i = 2 To j
Sheets.Add after:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Sheet18.Cells(i, "
13 matches
Mail list logo
