$$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread big smile
Respected Excel Guru's How to make the macro so that When ever i start the file my cursor goes into that particular cell only. For EX. Sheet 2 - A494 etc. The purpose behing this is ex. i have set the target of achieving certain amount -- so how much still pending to achieve. Thanks have a

Re: $$Excel-Macros$$ I love excel because.......

2010-09-02 Thread johnson john
One can run a Billion Dollars company with Excel without any ERP support. On Wed, Sep 1, 2010 at 9:41 PM, kamal shah kamal...@gmail.com wrote: Simply said than done. An IT Engineer starts career with Excel... reaches level of excellence in various technology and toolsbecomes Manager/

$$Excel-Macros$$ Re: CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread Kishan Reddy, K
Mr Salva, Just open visual basic editor (tools - macros - visual basic editor) Double click on This workbook in project explorer. copy paste this code in code window. Private Sub Workbook_Open() Sheets(Sheet2).Select Range(A494).Select End Sub Regards, Kishan Reddy, K On Sep 2, 9:28 

$$Excel-Macros$$ How to create Speedometer chart in Excel

2010-09-02 Thread Intelligent But Crazy
Hi Experts, -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread Aindril De
Hi, Please use the following code: *Private Sub Workbook_Open()* Sheets(Sheet2).Select Range(A494).Select *End Sub* Cheers! Andy On Thu, Sep 2, 2010 at 9:58 AM, big smile bigsmile...@gmail.com wrote: Respected Excel Guru's How to make the macro so that When ever i start the file my

Re: $$Excel-Macros$$ I love excel because.......

2010-09-02 Thread Rakhee Koshy
I like excel because All office/home work can be put in ONE ie., Excel !!! Elizabeth On Thu, Sep 2, 2010 at 10:05 AM, johnson john johnsond...@gmail.com wrote: One can run a Billion Dollars company with Excel without any ERP support. On Wed, Sep 1, 2010 at 9:41 PM, kamal shah

$$Excel-Macros$$ VB excel code throwing up error, out of my zone ..

2010-09-02 Thread paulexcel
Hi, I have a user who has approached me with an Excel coding issue. Here is the problem and the code. If anyone can run through this and fix then it would be most appreciated. I simply do not have the knowledge or skill in this area to assist. Run-time Error ‘9’: Subscript Out of Range which

Re: $$Excel-Macros$$ How to create Speedometer chart in Excel

2010-09-02 Thread Aindril De
Hi Pankaj, Pl go through this link http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm Regards, Andy On Thu, Sep 2, 2010 at 12:39 PM, Intelligent But Crazy secrets...@gmail.com wrote: Hi Experts, -- Pankaj Pandey Bhopal --

RE: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread Michael Brumby
subscribe to group at http://groups.google.com/group/excel-macros/subscribe __ Information from ESET Smart Security, version of virus signature database 5417 (20100902) __ The message was checked by ESET Smart Security. http://www.eset.com

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

2010-09-02 Thread amrahs k
Hi Vasant, I am trying to create a macro to do this below task to avoid manual efforts. For more details please refer the below email. Here is my code- Sub Movefiles() Dim a As Integer Dim fso, f2 With Application.FileSearch .LookIn = C:\LLF\ Range(A1).Value .FileType =

$$Excel-Macros$$ sumif kinda formula needed

2010-09-02 Thread Phillip Swanepoel
Hi This posting relate to a earlier one regarding birthdays on a excel sheet. in column b i got the /mm/dd column c i got the person name and last name column d i got the age of the person in h10 i need every one that has birthday today with theiry respective age next to the name. since

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread big smile
Sir. Thanks for your fast reply. I have put this in View Code. -- but stil it does not work until i press run in view code. I have another function also in that as follows Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread Aindril De
Hi, 1. You need to press Alt+F11, and open the visual basic editor. 2. Double click on This Workbook 3. Paste the code. *Private Sub Workbook_Open()* Sheets(Sheet2).Select Range(A494).Select *End Sub* 4. Save the file (For XL 2003 as .xls , or for XL 2007 as .xlsm) 5. Close the file and try to

Re: $$Excel-Macros$$ I love excel because.......

2010-09-02 Thread big smile
I am Insurance Advisor I my self has more then 2000 clients i have made excel as my base software which helps me to solve my all daily updates. Even the LIC Private Software is not giving that much satisfaction need base soultion which Excel gives me. Even I love this group also from which

$$Excel-Macros$$ I love excel because.......

2010-09-02 Thread Chidurala, Shrinivas
Dear All, I love Excel more than any Software in the World, I'm not alone, millions and millions of people around the world use it too and, more or less, Love it. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00