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

Hi Ruchi, try yhis, =A1 A2 A3 a space between each cells entries regards Srini On Wed, Aug 12, 2009 at 7:12 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Ruchi, I think you need the following formula: =A1CHAR(13)A2CHAR(13)A3 The cell format needs the Text Wrap option selected.

$$Excel-Macros$$ Re: Connecting excel to Google Translation

Hi All, I though this will be child's play for wizards like you. While I see that most of the queries posted after mine have been answered, my query has rcvd no response. I have a document available http://vbaexcel.eu/vba/google_translate_internet_explorer_automation.xls which is very near to

$$Excel-Macros$$ Re: help Needed!

If i understand your query correctly , then the solution would be as follows = 1. write the formula in J2 ... = I2 - D2 2. Copy the cell J2 (Ctrl + C) 3. Select the range J2 to J121 4. Paste (Ctrl + V) but since this is a very very very beginner

$$Excel-Macros$$ Re: Code to hide workbook

One workaround can be setting Application.screenupdating = false just before you open it. and then set the same to TRUE when you want to make it visible. Hope it helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On

$$Excel-Macros$$ Re: Number in Words

Hi Sachin You simply need to copy paste the code into your own workbook.. you can get access to the code by ALT + F11 Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 8, 2009 at 1:37 PM, sachin patil

$$Excel-Macros$$ Re: Anyone know this?

Hi Anil, Please find the solved workbook with explanation. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/11/09, Sandeep sandymau...@gmail.com wrote: Thanks Dilip, but this is not what I want.

$$Excel-Macros$$ Re: NAMED Range

Hi Suresh! can you please give an example of us to solve the problem might be you can add a example with your desired result.. Rgds Venkatesh On Tue, Aug 11, 2009 at 8:57 PM, suresh k brave.sur...@gmail.com wrote: Hi All, I have selected A1 to A5 and given some name(In Named Range). Now

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

Hi Dave, Your formula has worked Thanks Regards, Ruchi On Wed, Aug 12, 2009 at 7:27 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Ruchi, Sorry, correction: =A1CHAR(10)A2CHAR(10)A3 Regards - Dave. -- From: davebonall...@hotmail.com To:

$$Excel-Macros$$ Re: help Needed!

Hi Abdul Can you please provide an example. your file has the folloing fields Time of Call Recorded (T1) Tech.Deputed Time Tech. Arrival Time Tech. Responding Time Work Start Time Work Finish Time (T2) Restoration Time (T2-T1) Restoration Time In Mins. can you tell us what should be the final

$$Excel-Macros$$ Re: Need Help on Macro - image Resizing

Thanks Andy, Let me try and come back. cheers, Kamal On Thu, Aug 6, 2009 at 5:22 PM, Aindril De aind...@gmail.com wrote: Dear Kamal, Just add the following line to the top of your code to select all pictures in the worksheet ActiveSheet.Pictures.Select Hope this helps. Otherwise

$$Excel-Macros$$ Need help : Urgent

I need help with VBA Am working on a vba project. Trying to automate something. Am gonna be using a barcode reader and my employees have their iCards wit their employee id printed in barcode. Wat i need is ?? If someone comes to me with their id card i would not know if he is a supervisor or

$$Excel-Macros$$ Re: help Needed!

Hi Vivek, Thank you for such a quick response. What I want to do is to calculate the response time for the complete sheet with a single formula. As you have noticed that I am right now using individual formula to get the figure in each cell. By the end of month this sheet will be about 400 long

$$Excel-Macros$$ Re: Outlook

Well.. the problem is that you asked a question about Outlook in a discussion group that centers on programming in Excel. so, naturally they thought you wanted to use Excel. What you're asking is exclusively Outlook. I suggest you find a discussion group for Outlook. sorry... Paul

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

Hi Vivek, Thank you for your reply I found out it is very funny. i change the cell(containing date or time) format to Date , then i used function Datevalue() and timevalue(), they work! On Wed, Aug 12, 2009 at 10:50 AM, vivek agrawal vivek.agrawa...@gmail.comwrote: hi I think the

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar

Hello every body, I am unable to use this function in excell work book,whether it is possible? I am dont know about VBA,Please helpm of using this TIP, Regards On Tue, Aug 11, 2009 at 1:27 PM, ankur ankurpande...@gmail.com wrote: hello friends i dont know much about vba i had bring

$$Excel-Macros$$ Need Urgent Excel Help needed

Dear Expert Members. I need automatically hide or unhide the column without using macro. For Example: I will type Hide B the given cell A1 and excel should hide column B column I will type Unhide A in the given cell A1 and excel should unhide B column. Is this really possible without macros?

$$Excel-Macros$$ Re: Code to hide workbook

Savio, Place the following code in the Workbook_Open() event: ThisWorkbook.Windows(1).Visible = False If your workbook has more than one window, you'll need to iterate through the Windows collection hiding them all. Regarding breaking out of a loop or case, you could use a GoTo, though

$$Excel-Macros$$ Re: How to Make Excel Recalculate When Cell is Tied to VBA Macro

Hi Jeffrey, The way you've done it is correct. It looks as though your experiments have lead you to the correct conclusion, though I suspect you're a little unclear why. If you look at your first function, it doesn't take any inputs, so you can't use it to reference any other cells when you use

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

Hi Manoj, See the attached file... Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who

$$Excel-Macros$$ Re: Need Help on Macro - image Resizing

thanks Andy. It worked !! Kamal On Thu, Aug 6, 2009 at 5:22 PM, Aindril De aind...@gmail.com wrote: Dear Kamal, Just add the following line to the top of your code to select all pictures in the worksheet ActiveSheet.Pictures.Select Hope this helps. Otherwise please post your code

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

I didn't get this the meaning of this sheet..what am i supposed to do with it? On Wed, Aug 12, 2009 at 2:22 PM, Iqbal Shaikh iqbal.sw...@gmail.com wrote: Friends Can u solve this logo quiz? Iqbal S --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Help Needed

Hi Iqbal, You need password to RAR file or password remover for RAR files…. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar

Hi Shivashankar. Remove Private from VB Macro build, save and Close VB window n your job done. Any issues, please shout. Kamal On Wed, Aug 12, 2009 at 3:15 PM, shivashankar katageri shankarkatag...@gmail.com wrote: Hello every body, I am unable to use this function in excell work

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

Hi Iqbal, Do you want us to send the answers to the LOGO quiz ??? Regards, Abdul Rahman. On Wed, Aug 12, 2009 at 4:22 PM, Iqbal Shaikh iqbal.sw...@gmail.com wrote: Friends Can u solve this logo quiz? Iqbal S -- Warm Regards, Abdul Rehman. Woods are lovely, dark and deep