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
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
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
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
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
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
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
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
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
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 .
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
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
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
13 matches
Mail list logo