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

2010-11-30 Thread in . vaibhav
: Re: $$Excel-Macros$$ Bold a Text with Help Of Formula 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

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 ma

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. wrote: > Sir, > > Tha

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"

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 wrote: > 2010/11/29 Chandra Shekar > > > Hi, > > > Pls check this site it might help you. > > >http://www.mrexcel.com/forum/showthread.php?t=20611 > > >

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

2010-11-29 Thread roberto mensa
2010/11/29 Chandra Shekar > 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 formula can return

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 wrote: > with UDF you can not: > look here: > > http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_t

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 > Guys, Can anyone Help me to Bold the text with the help of Formula > > Eg. > > A1 Cell Contains "ABC" > > I Want to

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 y

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 blan