$$Excel-Macros$$ Re: Number of sheets in workbook equal to number of days in a month

2008-11-12 Thread Tom Jeffries
The attached worksheet contains a macro (AddSheets) that will create a specified number of worksheets ass you describe. If you have any questions let me know. Tom On Tue, Nov 11, 2008 at 7:56 AM, Ajay Varshney <[EMAIL PROTECTED]>wrote: > Hi, > > Is there any macro using which i could get number

$$Excel-Macros$$ Re: help on splitting into columns

2008-11-12 Thread Tom Jeffries
I noticed you were looking for a function rather than a subroutine. The attached file contains a function (BoldParse) that parses your strings. Use whichever meets your needs. Tom On Wed, Nov 12, 2008 at 2:27 AM, atta khan <[EMAIL PROTECTED]> wrote: > Hello All, > > What i want to do is to sepa

$$Excel-Macros$$ Re: help on splitting into columns

2008-11-12 Thread Tom Jeffries
The attached workbook contains a macro (ParseBold) that does what you describe. If you have any questions let me know. On Wed, Nov 12, 2008 at 2:27 AM, atta khan <[EMAIL PROTECTED]> wrote: > Hello All, > > What i want to do is to separate BOLD text from a string by a formula or VB > function. As

$$Excel-Macros$$ Re: What is array??

2008-11-12 Thread larry
If you are doing macro coding an array can be a variable that is a collection of values. It can be one or more dimensions depending on how it is set up. Check your Visual Basic reference on Dim or dimension for more info. It can also be a set of selected values in the EXCEL spread sheet. You will

$$Excel-Macros$$ Re: Macro for Login Page

2008-11-12 Thread TERTIUS KOSHY THOMAS
Thank you Tom. I think I got what I wanted. Regards, Tertius -Original Message- From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Tom Jeffries Sent: Wednesday, November 12, 2008 6:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Macro fo

$$Excel-Macros$$ Re: How can i print a range of worksheets from workbooks in a directory

2008-11-12 Thread suresh k
Hi Please remove me from this google groups. thnx On 11/12/08, Tom Jeffries <[EMAIL PROTECTED]> wrote: > I've attached a workbook containing two macros PrintWorkbooks and > Traversethat together do what you are describing. Invoke > PrintWorkBooks and provide the full starting path (e.g. C:\TES

$$Excel-Macros$$ Create a list of employees by experience level

2008-11-12 Thread Shreyas . Shringarpure
Hi All I have a query I have 3 columns which I want organized by number of employees + yrs of experience (0-5, 6-10,11,15,16-20,21-25) Pls help Thanks Shreyas --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.co

$$Excel-Macros$$ Re: I need your help for the below issue.

2008-11-12 Thread Dave Bonallack
Hi, Please see attached. Regards - Dave. Date: Tue, 11 Nov 2008 12:22:33 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ I need your help for the below issue. Hi all, I have explained all in the below attchment pls lookinto this and give your solution. Thanks and Regards

$$Excel-Macros$$ Re: help on splitting into columns

2008-11-12 Thread atta khan
Hello All, What i want to do is to separate BOLD text from a string by a formula or VB function. As I have a lot of data I can't do it manually. For example *East Doncaster* Victoria, Australia. I want "East Doncaster" in one column and "Victoria, Australia" in other. Please provide help than