$$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
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 nice day. C P SAVLA -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ I love excel because.......
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/ Director/ VP... ends up working again on Excel !!! So nothing changes.. First love remains First forever !!! Ask this question to any Director/VP in world, n it would be same answer. Cheers Folks Kamal Director - www.tisyalimited.com On Tue, Aug 31, 2010 at 3:35 PM, Rajesh Janardanan rajesh...@gmail.comwrote: Hi, I Love excel because it makes the finance manager in me to be more and more creative in financial analysis and impress my bosses. SAP/Excel helped my career in a big way :-) best regards rajesh On Tue, Aug 31, 2010 at 5:04 PM, sudhir kumar sudhir.p...@gmail.comwrote: hi , I love excel due to its mathematical interface, using excel is like u r solving a puzzle with some logic . On Tue, Aug 31, 2010 at 2:01 AM, obahor o oba...@gmail.com wrote: I love excel becuz it helps me excel in my day-to-day data manipulation and analytics solution. Mog Sent from my HTC Snap on the Now Network from Sprint®. -Original Message- From: Ayush jainayus...@gmail.com Sent: Sunday, August 29, 2010 10:05 PM To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I love excel because... Hi Guyzz, Come on ..Please participate in this If you dont respond, It means that you dont love excel. Express yourself !! Thanks to those who responded quickly :) -Ayush Jain Group Manager On Aug 29, 1:26 am, Vinod N nvino...@gmail.com wrote: Excel makes life simple Be it an analysis or dashboard or reports or any daily activities.. Just Excel it.. [?] I consider Excel as an Ocean and my knowledge is only a spoonful... I really love it and can go gaga over it anytime and every-time... On the lighter note: My wife calls Excel as my mistress [?] Whenever she sees me glued to the computer [?].. its always MS Excel that i'm working on... AND get kicked...[?]..but still I Love Excel... On Sun, Aug 29, 2010 at 1:20 AM, Dilip Pandey dilipan...@gmail.com wrote: I love Excel because it is excellent anaylitics package every user in the world is familar with its spreadsheets n welcomes the reports in Excel format. Thx n Regards, Dilip kumar pandey On 8/28/10, Ayush jainayus...@gmail.com wrote: Its a very handy tool for any data analysis and reporting. - Ayush Jain --- Guyzzz, Let me know why you like excel so muchThe best response will be published on the home page with thanks. Please continue in this thread only just below my line I want to see the active participation... Thank u so much. -Ayush Jain Group Manager -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Sent from my mobile device Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks and Regards Vinod
$$Excel-Macros$$ Re: CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
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 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 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 nice day. C P SAVLA -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to create Speedometer chart in Excel
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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
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 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 nice day. C P SAVLA -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ I love excel because.......
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 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/ Director/ VP... ends up working again on Excel !!! So nothing changes.. First love remains First forever !!! Ask this question to any Director/VP in world, n it would be same answer. Cheers Folks Kamal Director - www.tisyalimited.com On Tue, Aug 31, 2010 at 3:35 PM, Rajesh Janardanan rajesh...@gmail.com wrote: Hi, I Love excel because it makes the finance manager in me to be more and more creative in financial analysis and impress my bosses. SAP/Excel helped my career in a big way :-) best regards rajesh On Tue, Aug 31, 2010 at 5:04 PM, sudhir kumar sudhir.p...@gmail.comwrote: hi , I love excel due to its mathematical interface, using excel is like u r solving a puzzle with some logic . On Tue, Aug 31, 2010 at 2:01 AM, obahor o oba...@gmail.com wrote: I love excel becuz it helps me excel in my day-to-day data manipulation and analytics solution. Mog Sent from my HTC Snap on the Now Network from Sprint®. -Original Message- From: Ayush jainayus...@gmail.com Sent: Sunday, August 29, 2010 10:05 PM To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I love excel because... Hi Guyzz, Come on ..Please participate in this If you dont respond, It means that you dont love excel. Express yourself !! Thanks to those who responded quickly :) -Ayush Jain Group Manager On Aug 29, 1:26 am, Vinod N nvino...@gmail.com wrote: Excel makes life simple Be it an analysis or dashboard or reports or any daily activities.. Just Excel it.. [?] I consider Excel as an Ocean and my knowledge is only a spoonful... I really love it and can go gaga over it anytime and every-time... On the lighter note: My wife calls Excel as my mistress [?] Whenever she sees me glued to the computer [?].. its always MS Excel that i'm working on... AND get kicked...[?]..but still I Love Excel... On Sun, Aug 29, 2010 at 1:20 AM, Dilip Pandey dilipan...@gmail.com wrote: I love Excel because it is excellent anaylitics package every user in the world is familar with its spreadsheets n welcomes the reports in Excel format. Thx n Regards, Dilip kumar pandey On 8/28/10, Ayush jainayus...@gmail.com wrote: Its a very handy tool for any data analysis and reporting. - Ayush Jain --- Guyzzz, Let me know why you like excel so muchThe best response will be published on the home page with thanks. Please continue in this thread only just below my line I want to see the active participation... Thank u so much. -Ayush Jain Group Manager -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Sent from my mobile device Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the
$$Excel-Macros$$ VB excel code throwing up error, out of my zone ..
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 pops out every time I open the excel spreadsheet. Full Code is featured below. It does two things: 1. allows multiple entries in the same cell using the drop down options of a data validation function. 2. Allows the users to type their name in cell A1 which then automatically allows the user to locate the column containing their name. However, there are a number of problems: • when you delete the entry from within the cell itself, the end if statements loops so that even if the new value is deleted it would just replicate old and new entries hence the entries appears twice, three times or however many entries you delete. • There is a Microsoft Visual Basic – Run-time Error ‘9’: Subscript Out of Range which pops out every time the document is opened • Another dialogue box pops open when the document is saved - compatibility checker • ‘Summary – Minor loss of fidelity o Some formulas in this workbook are linked to other workbooks that are closed (NB: This spreadsheet has been taken off from the web but the sheets are hidden), When these formulas are recalculated in earlier versions of excel without opening the linked workbooks, characters beyond the 255 character limit cannot be returned…Location: Defined names o An embedded object in this worksheet is created in a newer version of office. You cannot edit it in an earlier version of excel…location: Read me. I’ll save a blank version on the h/general/jw The code…. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As String If Target.Count 1 Then GoTo exitHandler On Error Resume Next Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation) On Error GoTo exitHandler If rngDV Is Nothing Then GoTo exitHandler If Intersect(Target, rngDV) Is Nothing Then 'do nothing Else Application.EnableEvents = False newVal = Target.Value Application.Undo oldVal = Target.Value Target.Value = newVal If Target.Column = 2 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 3 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 4 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 5 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 6 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 7 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 8 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 9 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If If Target.Column = 10 Then If oldVal = Then 'do nothing Else If newVal = Then 'do nothing Else Target.Value = oldVal _ , newVal End If End If End If exitHandler: Application.EnableEvents = True Dim Found As Range If Target.Address(False, False) = A1 Then Set Found = Rows(3).Find(what:=Target.Value, LookIn:=xlValues, lookat:=xlWhole) If Found Is Nothing Then MsgBox Error in name! Else Found.Offset(1).Select End If End If End Sub -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at
Re: $$Excel-Macros$$ How to create Speedometer chart in Excel
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 -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
C P SAVLA You don't need a macro for this, just make sure that the cell is selected when you save the file and it will open in the same cell when you next open the file... Kind regards Michael UK From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of big smile Sent: 02 September 2010 05:28 To: EXCEL MACRO GROUP Subject: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE 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 nice day. C P SAVLA -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can 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 -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help Needed!
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 = msoFileTypeAllFiles .Execute MsgBox Total Files Available is : (.FoundFiles.Count) a = WorksheetFunction.Sum((.FoundFiles.Count) / 50) If .FoundFiles.Count 50 Then On Error GoTo 1 MkDir C:\Amrahs ' change the path and name MsgBox (Folder Created) Exit Sub 1 MsgBox (Folder Already Exist!) Else If .FoundFiles.Count 50 Then Do While a 0 MkDir C:\Target\Amrahs a MsgBox (Folder Created) Loop End If End If End With End Sub Am getting error message in the highlighted line. Also this code is only use to create folders based on number of files available in the specified folder. If the folder contains 500 files then it should be divided by a constant number 50 and you will get 10. So 10 folders needs to be created. Additonally while creating folders the code should move 50 files to the first folder and the next 50 files to the second folder and so on. At last all the 500 files should be moved to the respective 10 folders. If the file count is 480 or 500 then the remaining files should be moved to the last folder. Please look into this and help me to overcome this issue since it is very much required as every time am doing it manually. Any idea or suggestion will be greatly appreciated. Thanks a lot! -Sharma On Mon, Aug 30, 2010 at 12:36 PM, amrahs k amrahs...@gmail.com wrote: Dear Experts, I have a problem to work on a folder where in I need to do manually to do the below task. I have a folder named as Calibration in C: drive. It contains 500 excel files. What I want to do is to create new folder1 and move 50 files to it. Then another 50 files to new folder2 till the folder gets empty (i.e) all the files moved to new folder. Can we do it using VBA. Please suggest me to solve this issue. Regards, Sharma -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ sumif kinda formula needed
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 there might be more than one or even sometimes more than 2/3 a normal if then would not work... in h11 i need every on that has birthday tomorow again with their respective age next to. in h12 i need a list of every one that has birthday this month. this can be with out the age. then i got the userform with the labels and will pull d1 , d2 , d3 to the labels... Thank you guys Phillip Swanepoel pswa...@gmail.com (JanPhi) 0825360597 0287134213 34° 4'58.48S, 21°14'51.33E This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe birthdays-Andy_01.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
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 Target.EntireRow.Insert End Sub due to which the problem comes Whenever i close my cursor is for Ex. on A392 but whenever i reopen this file it should be on ex. A494. One more thing the soultion given by Michael Brumby that i know sir Then also thanks for the answer. Thanks Have a nice day CP SAVLA On Thu, Sep 2, 2010 at 1:05 PM, Aindril De aind...@gmail.com wrote: 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 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 nice day. C P SAVLA -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
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 open it. This should run the code. NOTE: The macro might not run in case the macro security is set to High. You have to lower the Macro Security to make it work. Please let me know if you need any further help on this. Regards, Aindril On Thu, Sep 2, 2010 at 6:10 PM, big smile bigsmile...@gmail.com wrote: 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 Target.EntireRow.Insert End Sub due to which the problem comes Whenever i close my cursor is for Ex. on A392 but whenever i reopen this file it should be on ex. A494. One more thing the soultion given by Michael Brumby that i know sir Then also thanks for the answer. Thanks Have a nice day CP SAVLA On Thu, Sep 2, 2010 at 1:05 PM, Aindril De aind...@gmail.com wrote: 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 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 nice day. C P SAVLA -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at
Re: $$Excel-Macros$$ I love excel because.......
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 we can learn so much. I am difinetly 100 % sure if you used Excel atleast more than 50 % of its all function then there is nothing like this. but what we are using only 10 % of its use. No software can challence accuracy compare to EXCEL. Still we have to learn lot of things in EXCEL. It gives me lot of new ideas to do the things this way or that way. Our group should be mutilply by double no of person every year. From 7000 to 14000 ..every year. Thanks a lot for this group efforts all the very best. CHANDRESH P SAVLA LIC GIC Advisor. -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ I love excel because.......
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 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe