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

2009-08-12 Thread Abdul Rehman
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 wrote: > Friends > > Can u solve this logo quiz? > > > > > > > > > Iqbal S > > > > -- Warm Regards, Abdul Rehman. "Woods are lovely, dark and deep But I h

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

2009-08-12 Thread kamal shah
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 bo

$$Excel-Macros$$ Re: Help Needed

2009-08-12 Thread Upendra Singh
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 wh

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

2009-08-12 Thread zheng yu
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 wrote: > Friends > > Can u solve this logo quiz? > > > > > > > > > Iqbal S > > > > --~--~-~--~~~---~--~~ -

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

2009-08-12 Thread kamal shah
thanks Andy. It worked !! Kamal On Thu, Aug 6, 2009 at 5:22 PM, Aindril De 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 here so tha

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

2009-08-12 Thread Upendra Singh
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 don't.

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

2009-08-12 Thread Chris Spicer
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: Code to hide workbook

2009-08-12 Thread Chris Spicer
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 you

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

2009-08-12 Thread Manoj Kukrej
Hi want to insert "=" sign before each no. for variety of calculation purpose see attached file Manoj From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Aindril De Sent: Wednesday, June 24, 2009 9:15 PM To: excel-macros@goog

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

2009-08-12 Thread vinod rao
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? Ki

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

2009-08-12 Thread shivashankar katageri
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 wrote: > > hello friends > i dont know much about vba > i had bring calender to my sheet, but

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

2009-08-12 Thread zheng yu
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 wrote: > > hi > > I think the returnvalue of the time

$$Excel-Macros$$ Re: Outlook

2009-08-12 Thread Paul Schreiner
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: help Needed!

2009-08-12 Thread Abdul Rehman
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 an

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

2009-08-12 Thread shafiq online
If your given answer is correct than just drag till the last dat. Time will be calculated automatically Date: Wed, 12 Aug 2009 11:23:00 +0400 Subject: $$Excel-Macros$$ help Needed! From: stevejamesrica...@gmail.com To: excel-macros@googlegroups.com Hi All, Can anyone guide me how to i

$$Excel-Macros$$ Need help : Urgent

2009-08-12 Thread Murtaza Dalal
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 jun

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

2009-08-12 Thread kamal shah
Thanks Andy, Let me try and come back. cheers, Kamal On Thu, Aug 6, 2009 at 5:22 PM, Aindril De 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

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

2009-08-12 Thread venkatesh srinivas
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 res

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

2009-08-12 Thread Ruchi Saxena
Hi Dave, Your formula has worked Thanks Regards, Ruchi On Wed, Aug 12, 2009 at 7:27 AM, Dave Bonallack wrote: > Hi Ruchi, > Sorry, correction: > =A1&CHAR(10)&A2&CHAR(10)&A3 > Regards - Dave. > -- > From: davebonall...@hotmail.com > To: excel-macros@googlegroups.com

$$Excel-Macros$$ Re: NAMED Range

2009-08-12 Thread venkatesh srinivas
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 wrote: > Hi All, > > I have selected A1 to A5 and given some name(In Named Range). > > Now I want to remove

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

2009-08-12 Thread Dilip Pandey
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 wrote: > Thanks Dilip, but this is not what I want. > > This is the Attac

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

2009-08-12 Thread vivek agrawal
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 wrote: > Dear Mr.

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

2009-08-12 Thread vivek agrawal
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 Tu

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

2009-08-12 Thread vivek agrawal
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 qu

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

2009-08-12 Thread RK
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 w

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

2009-08-12 Thread Srinivasulu Reddy Yarasi
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 wrote: > Hi Ruchi, > I think you need the following formula: > =A1&CHAR(13)&A2&CHAR(13)&A3 > The cell format needs the Text Wrap option selected. > Regards -