AhmedThe run-time error resulted when the macro attempted to create a new
tab having the same name as an existing tab when it was invoked a second
time.
I've attached a modified version of the macro that addresses this problem.
When activated the macro will first prompt you for a unique prefix fo
*Is there any code which would delete sheets for old month and insert sheets
for new month?*
On Thu, Nov 13, 2008 at 10:47 AM, Ahmedhonest <[EMAIL PROTECTED]> wrote:
> Hello Tom,
>
> The coding for the macro which you have written is good and I would like to
> draw your attention is that The
Hi,
You could perhaps use =NOW() +/- time difference/24
eg =Now()-(11/24)
Regards - Dave
Date: Thu, 13 Nov 2008 15:04:09 +0530From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: $$Excel-Macros$$ Time Format
HI All
Greeting you all mebers , I have a problems in formula function . I want use
=NOW()
Sorry,I am attaching a copy of the login macro with the IDs unhidden. Use
any of the names in column 1.
Tom
On Wed, Nov 12, 2008 at 11:10 PM, swamy nadan <[EMAIL PROTECTED]>wrote:
> Hi, Tom
>
>
> let me know the user name to open..
>
>
> Regards
>
> M.A. Swaminadane
>
> On Wed, Nov 12, 2008 at
The attached worksheet contains a macro (AddSheets) that will create a
specified number of worksheets as you describe. If you have any questions
let me know.
I am resending this message due to an email problem at my end.
Tom
On Wed, Nov 12, 2008 at 5:20 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote
Hi, Tom
let me know the user name to open..
Regards
M.A. Swaminadane
On Wed, Nov 12, 2008 at 4:13 AM, Tom Jeffries <[EMAIL PROTECTED]> wrote:
> The attached file does what you describe. When a workbook opens Excel
> automatically executes a module named "Auto_Open". I used Auto_Open to
> d
Dear Tom Jeffries,
I really felt happy to see the macro code you have build up for solving the
problem of separating Bold Strings for your reference is BoldParse Macro.
Tom just i need one help from you is that can you tell if a person doesnt
knows about the Macros for building up the code and ge
Hello Tom,
The coding for the macro which you have written is good and I would like to
draw your attention is that The first when the Macro is runned then there is
no problem at all and it inserts the given input for inserting the sheets.
If the macro is runned for the second time for inserting mo
HI All
Greeting you all mebers , I have a problems in formula function . I want use
=NOW() For India ,=NOW() for USA etc in sinle sread sheet how it will please
suggest me
Regards
Alok Dbs
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http
