$$Excel-Macros$$ Re: NUMBER STORED AS TEXT

Dear Shez, Try out the option in excel help menu.. anyways am pasting same solution here.. let me knw if i am wrng in understanding ur question..:) In an empty cell, enter the number 1. 1. Select the cell, and on the *Edit* menu, click *Copy*. 2. Select the range of numbers stored as text y

$$Excel-Macros$$ Tip # 44 Open Web pages right in Excel

Dear Members, A new tip of excel has been published on the blog . The title of the tip is "Open Web pages right in Excel". Please visit the below link for this tip. http://exceldailytip.blogspot.com/2008/12/tip-44-open-web-pages-right-in-excel.html To see the archive of these Daily Excel Tips,

$$Excel-Macros$$ How to Deleted Zpharaoh.exe

Hello to everyone, The below Question may be out of Context but i need help. I sincerely Thanks you guys in advance Problem is that I am unable to open my D,E,F Drives when i am double clicking on it, It gives an error message stating that Zpharaoh.exe file is missing. When I searched on the G

$$Excel-Macros$$ Re: NUMBER STORED AS TEXT

guys, I really appreciate all the responses, but I had mentioned that the email generation is a automated process without any human intervention. Data is exported and email on an event daily int he morning. So the point of copy pasting and opening is not an option for me. I I click that little gre

$$Excel-Macros$$ Re: How do I create formula to return row number of search result...

The following should help you. If you have any questions let me know Sub FindIt() Dim What As String What = InputBox(" Enter a search string ", "Search String") Set Found = ActiveSheet.UsedRange.Find(What) If Not Found Is Nothing Then r = Cells.Find(What).Row Msg

$$Excel-Macros$$ Re: creating a text file

The following macro does what you want. Note it must be named Auto_Open to run automatically when the workbook is opened. Sub Auto_Open() ' ' When Workbook is opened if Cell A1 is empty create ' a text file having same name as the WorkBook ' If Cells(1, 1).Value = "" Then

$$Excel-Macros$$ Random selection of data from a cell in a column from self-creating range?

I am trying to extract a random cell from a range listed below it. The pool differs for every item and no range size is the same with some being 110 columns down and others 80 and so forth. This seems almost like a Edit>Go To>Special>Blanks Fill but more advanced so as to randomly call one of the

$$Excel-Macros$$ Re: creating a text file

Sorry , I place signature within code... On Tue, Dec 23, 2008 at 5:27 PM, Tom Jeffries wrote: > The following macro does what you want. Note it must be named Auto_Opento > run automatically when the workbook is opened. > Sub Auto_Open() > ' > ' When Workbook is opened if Cell A1 is e

$$Excel-Macros$$ Re: Auto Mail Micro

Thanx Girish, But the MACRO is not working. Regards Atul -Original Message- From: girishkr...@gmail.com [mailto:girishkr...@gmail.com] Sent: December 23, 2008 11:18 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Auto Mail Micro Hi Harish, I have done a macro hat can se

$$Excel-Macros$$ Re: NUMBER STORED AS TEXT

Hello, If you have green mark due apostrophe than this link can be helpful. How to remove apostrophe Regards, Sarfaraz On Fri, Dec 19, 2008 at 8:02 PM, Dave Bonallack wrote: > Hi, > Not sure if you can use this, but the f

$$Excel-Macros$$ Re: excel ebook

Please reply need more ebooks. On Sun, Dec 21, 2008 at 7:40 PM, Naveen Sharma wrote: > Hey sunil, > > Thank you very much. I think this is a gr8 help for those who don't know > about excel. > > Also, All members of this group, if any not found reply me, I will forward > it. > > Regards, > Naveen

$$Excel-Macros$$ creating a text file

Dear Members, Is it possible to create a text file on condition? For example, when file opens, vba should check whether A1 cell is empty or not. If empty it automatically create a text file, and put the word "empty" in it. Is that possible? If not does anyone tell me how can I access "cells" in

$$Excel-Macros$$ Re: Copy past value from on downword on the sheet trough macro

u can use.Ctrl+D for copying same values downwards. On Tue, Dec 23, 2008 at 3:38 PM, Alok Dbs wrote: > HI All > > Can any body help me for Macro apply or provide me a codeing for > copy paste on value of value format from same file spread sheet > on downword basis of the sheet . > > > plea

$$Excel-Macros$$ Re: How to calculate Hours and miutes between two dates.

Try this formula =(DATEDIF(A1,B1,"D")*24+INT(TEXT((B1-A1),"H")))&":"&RIGHT(TEXT((B1-A1),"H:MM"),2) Let me know if it does not help you. On Tue, Dec 23, 2008 at 3:30 PM, Santhosh Kumar M K wrote: > Hai Ajay, > > My question is > > Cell A1 = 12/20/2008 5:25:00 AM > Cell B1 = 12/23/2008 1:00:

$$Excel-Macros$$ Re: How to calculate Hours and miutes between two dates.

Hai Ajay, My question is Cell A1 = 12/20/2008 5:25:00 AM Cell B1 = 12/23/2008 1:00:00 PM calculate the number of hours and minutes between these above two dates. Answer Formate = __ *:* __ (hh*:*mm) Thanks for your help. Rgds, Sunny On Fri, Dec 19, 2008 at 3:19 PM, Ajay Varshney wro

$$Excel-Macros$$ Re: NUMBER STORED AS TEXT

HI ALL, I have a Excel table having the following fields. Column A contain Dates and column B contains Product Name. I need a macro which will count the values based on Multiple criteria. I am able to accomplish the desired task using an excel formula i.e. =SUMPRODUCT((A$1:A1$0=A1)*(B$1:B1$0=B1)

$$Excel-Macros$$ Copy past value from on downword on the sheet trough macro

HI All Can any body help me for Macro apply or provide me a codeing for copy paste on value of value format from same file spread sheet on downword basis of the sheet . please feel very urgent work then send me expected code solution for same Regard's Alok Dbs --~--~-~--~~---

$$Excel-Macros$$ Re: Macro in VBA which open word files and close them

Hope so this might solve your half the problem. This function may be used for opening a list of files in a given folder and then open each of the file and close the file. This can be directly used in word VBA itself. But before running this procedure add reference as "Microsoft Running script".

$$Excel-Macros$$ Re: Userform and xlup function

HI phillip, This code would be useful to complete up your task. textbox20.Value = Sheets("Sheet17").Range("B9").Value & Sheets ("Sheet17").Cells(Sheets("Sheet17").Range("K65535").End(xlUp).Row, "K").Value textbox21.Value = Sheets("Sheet17").Range("A9").Value & Sheets ("Sheet17").Cells(Sheets("S

$$Excel-Macros$$ Re: Auto Mail Micro

Hi Harish, I have done a macro hat can send mail using outlook this may be useful for you. http://groups.google.com/group/excel-macros/web/mail.xls?hl=en Regards Girish K Rao --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-m