$$Excel-Macros$$ Re: Timevalue and Datevalue suddently doesn't work any more

2009-08-13 Thread vivek agrawal
thats great :0 but the excel file which you sent already contained those sells in the date and time format Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:16 PM, zheng yu vincent2...@gmail.com wrote:

$$Excel-Macros$$ Re: Help Needed

2009-08-13 Thread vivek agrawal
the zip is password protected Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:42 PM, Iqbal Shaikh iqbal.sw...@gmail.com wrote: Hi All Can u help me for open the XL file which is in ZIP. Iqbal

$$Excel-Macros$$ Re: Logos Quiz !!

2009-08-13 Thread vivek agrawal
no info about how to fill those text boxes any idea?? Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 5:52 PM, Iqbal Shaikh iqbal.sw...@gmail.com wrote: Friends Can u solve this logo

$$Excel-Macros$$ Re: insert = in every cell with nos Blank

2009-08-13 Thread vivek agrawal
attached is the file... hope this is the solution required Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 12, 2009 at 8:44 PM, Manoj Kukrej manoj...@ocimumbio.comwrote: Hi want to insert = sign before each

UPENDRA RE: $$Excel-Macros$$ Re: insert = in every cell with nos Blank

2009-08-13 Thread Manoj Kukrej
Thanks , But my column has link with other cells , so I want to to change in the same field From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Upendra Singh Sent: Wednesday, August 12, 2009 10:00 PM To:

$$Excel-Macros$$ Re: NAMED Range

2009-08-13 Thread N.Shivkumar
Dear Suresh The same way how you created name i.e. from A1 to A5. Go to Insert -Name - Define and then delete the named range. It is that simple N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: Hii..

2009-08-13 Thread Prashanth Banneni
Hi Ruchi, Type this in B1 =A1 A2 A3 Thanks Prashanth On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote: Hi Friends, I have data in three cell A1= My Name A2= is A3= Ruchi can i have a formula wherein the below info in cell A1,A2 A3 appears in *single cell *

$$Excel-Macros$$ help How to use control

2009-08-13 Thread Aligahk06
Dear All, Can any body assist me regarding media player in Excel workbbok. I have added windows media player in excel workbook through Developer Tab - Insert Control- Windows media player. successfuly located at excel sheet. But i want to play a media file and my filoe is located in some

$$Excel-Macros$$ protect track changes from Accept or Reject Changes option

2009-08-13 Thread ankur
Hello Excel Gurus is there any way to disable the Accept or Reject Changes option i dont want anybody else to accept or reject changes made in the excel sheet i want to put password in that option urgent reply needed Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone

$$Excel-Macros$$ Re: MS Access

2009-08-13 Thread Aligahk06
http://www.accessmvp.com/strive4peace/ On Aug 4, 5:32 pm, suresh k brave.sur...@gmail.com wrote: Hi All, Please let me know if anyone know about MS Access or provide me any link, where i can find help. Regards, Suresh --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: insert = in every cell with nos Blank

2009-08-13 Thread Manoj Kukrej
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of vivek agrawal Sent: Thursday, August 13, 2009 5:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: insert = in every cell with nos Blank attached is the

$$Excel-Macros$$ Re: IF Condition

2009-08-13 Thread apparao asv
=AND(B45,E42,H42) Use above formula and filter wit TRUE On Fri, Aug 7, 2009 at 9:53 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: =IF(B45,IF(E42,IF(H42,Yes,No), No), NO) On Aug 6, 5:53 pm, Putta Madaiah puttamada...@gmail.com wrote: Hi All, Can anyone provide me the

RE: UPENDRA RE: $$Excel-Macros$$ Re: insert = in every cell with nos Blank

2009-08-13 Thread Upendra Singh
Copy and paste values in the required column. I just leave it so that you can understand the implementation. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are

$$Excel-Macros$$ Re: insert = in every cell as prefix with nos Blank

2009-08-13 Thread Manoj Kukrej
suppose i have list and want to insert X' or ='' before each no., is there any way to insert the item(x,=) as prefix by using find Replace method or any other method From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Manoj

$$Excel-Macros$$ Re: Excel vba for outlook

2009-08-13 Thread Rakesh Sharma
Hi, If you use the below code, you don't need to use any mail client (i.e outlook). you can send mail using any application either excel, access etc Sub Sendmail() Set imsg = CreateObject(CDO.Message) Set iConf = CreateObject(CDO.Configuration) iConf.Load -1 ' CDO Source Defaults Set Flds =

$$Excel-Macros$$ Re: insert = in every cell as prefix with nos Blank

2009-08-13 Thread Dave Bonallack
Hi, I think you'll have to use VBA. Have a look at the attachment. Select the cell you want to change, then press Ctrl+q However. the cell is then treated as text, and cannot be used in calculations. Is this what you need? Regards - Dave. From: manoj...@ocimumbio.com To:

$$Excel-Macros$$ TIP: Resize an Array Formula to Its 'Natural' Size

2009-08-13 Thread Chris Spicer
Ever find it difficult to resize an array formula to the right size? This is some useful VBA to help you work with array formulas on your worksheets. I've added this to an add-in (Technicana Utilities) and assigned it to CTRL+SHIFT+A. You can download a copy at