$$Excel-Macros$$ Printing In Excel - VBA

2009-10-22 Thread OSAVentures Calamba
Good day All, I'm writing to request your idea. Here is my problem. I have a template workbook with many multiple sheets. In one sheet(1) I have values in a column A. say row1 = 1, row2=2.. and so on... I want to print a certain range in another sheet(2) up to the last value in column a of she

$$Excel-Macros$$ Excel Chart Macro to Set Axis Values

2009-10-22 Thread Wataridori
Hi all, I was wondering if there is a way to set the axis values of a scatter chart to the maximum and minimum values given in the source data. For example, with the following data: Date Val 1/1/1010 2/20/10 15 3/15/106 4/31/10 19 I want the X axis range to be between 1/1/10 an

$$Excel-Macros$$ Re: Name Matching In Excel

2009-10-22 Thread Umesh Dev
Hi Dilip, Thanks for the help. I was trying to learn myself but could not. I need your help from the scratch for eg:- IF(ISNUMBER(MATCH("*"&MID(C4,1,FIND(" ",C4)-1)&"*",$A:$A,0)),"Mapped","Not Found Pls explain me from the root as to why you have used Isnumber, match and "*" etc Happy belated Di

$$Excel-Macros$$ Re: Run Excel Macro?

2009-10-22 Thread Joe C.
first suggestion, create two instances of excel. have one do your macros, the other you can use freely. maybe your concern is not with excel, but the weight of your SQL queries. if you're aggregating a large amount of data, the time it takes your DB server to process the query will freeze your

$$Excel-Macros$$ Re: Problem with filters in Excel 2007

2009-10-22 Thread aju chacko
HI Mahesh Bisht, Please try to keep the cursor in data area instead of column heading while you are copying the data,Also Microsoft has announced a patch to solve this problem which I will give you shortly. AJU On Tue, Oct 20, 2009

$$Excel-Macros$$ Re: Excel Query

2009-10-22 Thread Hemant Hegde
Hi Malek* *I have attached the solution to your problem. But can you people please give some introduction about your querry in the message? This is because many people including me like to go through interesting querries but without spending much time on downloading the attachment.. Regards He

$$Excel-Macros$$ Re: Insert file path and name into cell

2009-10-22 Thread Deepak Rai
Hi Hemant, Nice logic. It will also be very helpful. Regards, Deepak Rai On Thu, Oct 22, 2009 at 7:41 PM, Deepak Rai wrote: > Hi JP, > > Please find the below VBA code for the solution of your problem. Hope this > will help you. > > Private Sub Workbook_SheetSelectionChange(ByVal Sh As Objec

$$Excel-Macros$$ Re: Insert file path and name into cell

2009-10-22 Thread Deepak Rai
Hi JP, Please find the below VBA code for the solution of your problem. Hope this will help you. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) a = ActiveCell.Address For i = 1 To 10 On Error Resume Next If a = ("$A$") & i Then If Range("A" & i).Value < 1 T

$$Excel-Macros$$ Excel Query

2009-10-22 Thread ffradmin
Can any one solved my problem?? Malek Sarfraj DISCLAIMER: Please note that this e-mail and its attachments are intended for the named addressee only and may contain information that is confidential and privileged. If you have by coincidence or mistake or without specific authoriza

$$Excel-Macros$$ To insert new row if

2009-10-22 Thread Hassan Tariq
Dear All, Please help is it possible for Macro to insert a new row if column B of previous row is blank and the row before of Column B includes 8-digit code. For Example Column B Row 8 Row 9 Row 10. Row 11 Row 12 Row 13 Row 14 Row 15 .

$$Excel-Macros$$ Re: Is this possible and how

2009-10-22 Thread Alexander Cargill
My fault for nt explaining J sorry my ma and much appreciated J From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack Sent: 22 October 2009 05:41 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Is this possible and how Hi Alex

$$Excel-Macros$$ Re: Insert file path and name into cell

2009-10-22 Thread Hemant Hegde
Use this code Jp, Sub get_path () Dim x as string x=Application.getopenfilename If not x="FALSE" then: Activecell=x End sub :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important lin

$$Excel-Macros$$ Formula to retrieve only numbers in a Cell

2009-10-22 Thread NOURREDINE BELHAJ
Hi All, I need some help. I have a cell where there is Account Number and Cust Name and a codification before the Acct Num. *PlanGroup* P#C1299 J L Morison (India) Ltd I would like a formula that is taking only numbers from this cell. Could you help with this ? Thanks -- Regards Nou