Re: $$Excel-Macros$$ How to separating multiple data fileds in a single cell

2010-05-18 Thread santhosh qatester
Hi, 1.Select the contents which are merged and copy in to notepad 2.Now Open the excel sheet 3. Click on from text in the Data Tab 4.Select the file and click on import 5.Select delimitedand click on Next and tehn select space and tab 6.click on finish 7.Select the cell 8.Contents are displayed in

Re: $$Excel-Macros$$ Excel Daily Tip : Save Workspace

2010-05-18 Thread Harpreet Singh Gujral
Thanks Ayush, Looks like an excellent idea, will try it today and post my reviews about the TIP Harry On May 18, 8:36 am, Ayush Jain wrote: > Ayush Jain has sent you a link to a blog: > > Dear group, Here is a wonderful tip: One can open a group of workbooks > in a single step by creating a wor

Re: $$Excel-Macros$$ range method not working

2010-05-18 Thread sudhi na
This group is a real treasure although I'm checking the group mails after a long time. Experts are contributing their knowledge and replying with valuable solutions. Congrats to them and keep the same spirit always! mean while, Dear Tushar, Instead of using range I've used another simple method

$$Excel-Macros$$ Is it possible that a sub procedure will do certain steps and at the end it will delete itself

2010-05-18 Thread Hiren Sheth
Hi, Is it possible that a sub procedure will do certain steps and at the end it will delete itself. Seems to be a strange question but is it possible? Regards Hiren This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No c

Re: $$Excel-Macros$$ Macro to send emails using excel list

2010-05-18 Thread WizExcel
This is Superb Mahesh. really helpful for anyone who wants to send repetitive emails to a list of persons. Can anyone please also tell me its utility from Finance Dept. point of view, what functions have you used this Macro for. thanks Sameer On May 15, 10:49 am, Mahesh parab wrote: > Hi > In

$$Excel-Macros$$ Need macro

2010-05-18 Thread vidyut more
Hi Dear Member i want macro code for in excel sheet in which data is entered in any cell all rows will protected and empty rows will unprotected. Plz send me macro code. -- -- Some important links for excel users: 1.