Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-30 Thread in.vaib...@googlemail.com
Dear Rahul Pl explain the procedure, if you are saying you will be sending it to 9000, then will you be using mail merge or not. If not how u will be sending (i.e. using which application) to 9000 employees. Rgds Vaibhav J On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi.

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-30 Thread Rahul Kamal Gandhi
Vaibhav, I wrote an macro in excel where in the macro automatically find the to, cc, subject, mail body, attachment name, attachment extention, and attachment path, send on behalf of name The above attributes are already been defined in excel What actually I want is to do some formatting in

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-30 Thread in . vaibhav
Hi, If possible send that file and how do u send email through Outlook, OL express or through CDO. Sent on my BlackBerry® from Vodafone -Original Message- From: Rahul Kamal Gandhi myname.ra...@gmail.com Date: Tue, 30 Nov 2010 12:57:55 To: in.vaib...@googlemail.comin.vaib...@gmail.com

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Chandra Shekar
Hi, Pls check this site it might help you. http://www.mrexcel.com/forum/showthread.php?t=20611 Thanks Chandra Shekar On Mon, Nov 29, 2010 at 4:23 AM, roberto mensa robb@gmail.com wrote: with UDF you can not: look here:

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread roberto mensa
2010/11/29 Chandra Shekar chandrashekarb@gmail.com Hi, Pls check this site it might help you. http://www.mrexcel.com/forum/showthread.php?t=20611 Thanks Chandra Shekar get.cell returns (not set) information about the formatting, location, or contents of a cell. A function used in a

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Rahul Gandhi.
Dear Team, I Checked the appendedlinks, It only shows the Format, I want my output in bold format. Thanks On Nov 29, 3:54 pm, roberto mensa robb@gmail.com wrote: 2010/11/29 Chandra Shekar chandrashekarb@gmail.com Hi, Pls check this site it might help you.

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-29 Thread Rahul Gandhi.
Sir, Thanks for the prompt action, But I have a Data of 9000 Employees. I have to Send the Letters to Employees without using the Mail Merge. Only with The Hlp of Concatenate. Eg. =Your Salary is increased with Rs. A1/- Please find enclosed attachment which contains the breakup of amount

$$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-28 Thread Rahul Kamal Gandhi
Guys, Can anyone Help me to Bold the text with the help of Formula Eg. A1 Cell Contains ABC I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) And My output should be *ABC* But in Bold Format Any Formula or Code. Please Guys I am Struck Regards, Rahul Gandhi

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-28 Thread Dilip Pandey
Hi Rahul, I dont think there is any existing function using which you can bold at text. Considering your problem, I have thought of one smart way :- let say A1 has the text which needs to be bold. Go to B1 and type the formula =a1. Now apply conditional formatting in B1 that if cell B1 is not

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-28 Thread Simran Singh
Hi Rahul, You can do this with the help of replace option. Ist open the replace option by pressing ctrl + H. 2nd on Find What option write abc or any text you want to bold. 3rd on Replace With write abc or any text you want to bold. 4th on the right hand side of the Replace with option you

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010-11-28 Thread roberto mensa
with UDF you can not: look here: http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_the_worksheet_oh_yeah/ regards r 2010/11/28 Rahul Kamal Gandhi myname.ra...@gmail.com Guys, Can anyone Help me to Bold the text with the help of Formula Eg. A1 Cell Contains