Hi All,
I believe Sajid's email id has been hacked as I have also received
similar kind of emails from his email id in past 2 -3 days.
Regards,
DILIPandey
On 4/13/12, SAJID MEMON wrote:
>
>
> "Hi,bro! What's up? You know what. Recently I find a really nice website,
> zol-gyyg.com
> You can fin
The ROW() function specifcally and always returns an array.
You can see this with
?typename(evaluate("row()"))
which will state "Variant()" which means an array of variant (the array will
only have one element).
ROUND returns a single value. It requires Excel's array formula processor
to achieve
Hi Haseeb,
Thank you for your prompt reply.
There appears to be a lot to get my head around here so I will now try to
understand it!
Many thanks!
On Thursday, 12 April 2012 18:09:52 UTC+1, Haseeb A wrote:
>
> Hello Kenrock,
>
> Assume you will have header in row 1 & data starts on A2 onwards. So
Hello Kenrock,
Assume you will have header in row 1 & data starts on A2 onwards. So the
below formula will sort the data alphabetically without duplicates.
In B2 with CTRL+SHIFT+ENTER, rather than just ENTER. then copy down as
necessary.
If you are on XL2007 or later,
=IFERROR(INDEX(A$2:A$100
I thought about that issue but discounted it because I saw exampls on
the web like evaluate("sin(45)") which I considered morally
equivalent.
I guess not. So what do you think adding the ROW(), here is doing
exactly? It does work for me too.
On Thu, Apr 12, 2012 at 12:21 AM, Asa Rossoff wrote
It was made to work with this change. Speculation is there is a VBA
bug. There is no reason for the Len except maybe to accomplish what
this does which
is to change the code enough so that it compiles/interprets correctly
tmprange.Value2 = .Evaluate("transpose(transpose(round(" &
tmpran
I have the word "London" in cell A1, "Paris" in A2, "Bonn" in A3 and
"Madrid" in A4. I put the formula =A1 in cell B1, =A2 in B2, in B3 =A3 and
in B4, I put =A4. I will then see a copy of column A in column B
I want to sort B1:B4 alphabetically so that B1 will hold =A3, that is, the
first wo
Sir,
This works fine.Thank u very much.
Karunanithi R
From: Jaysheel Bhasme
To: excel-macros@googlegroups.com
Sent: Wednesday, April 11, 2012 11:55 PM
Subject: Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO
DATES
Hi,
Please find the at
Sir,
This works fine. I got what I expected.
Thanks.
Karunanithi R
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Thursday, April 12, 2012 12:11 AM
Subject: RE: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO
DATES
See the at
http://www.pivot-table.com/excel-pivot-tables/excel-pivot-table-keyboard-shortcuts
http://office.microsoft.com/en-us/excel-help/basic-keyboard-shortcuts-2-32-RZ102673162.aspx?section=3
http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx
On Thu, Apr 12,
hi
please provide shortcuts related to pivot tables and shortcut for
converting sheet details in numbers via keyboard.
On Apr 4, 2012 4:18 AM, "santosh subudhi"
wrote:
> Hi Group,
>
> I want to prefix a picture in the userform caption in excel.
>
> Would request to help me with that.
> --
> Rega
That helps alot Asa, now I understand why I see that people use classes
when working with Userforms. I can also use them when working with objects
such as charts. As far as what I read online, the subs should dictate the
flow of the program and the classes should manage the individual objects
s
or if anyone following this link, can look at the original sheet that I
wrote and add in the code.
On Thursday, April 12, 2012 4:24:38 AM UTC-4, Ratedr wrote:
>
> is there a way you can add that code into one of the cells (like in , for
> example k4, stating "(=if d4=d5)+(ife4=e5)+iff4=f5) and s
Dear All,
We are looking for a person with 1-3 years of exp. Salary band could be 1-3 Lac.
Please provide current & expected CTC too with your CV.
JD -
1) To collect the data from the various parties/system,
2) To prepare daily/weekly/monthly MIS,
3) To provide analysis of the MIS,
4) To provid
Sometime ActiveX does not work properly with Excel 2007, it's a bug , you
can use Form Control and Shapes instead of them
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Thu/2012 03:33
To: excel-macros@googlegroups.com
Gnanan info hyderabad will be provide online VBA traing. you can call
to 09703091552 or gnanainfo@gmail.com
Thanks
Narasimha
On 4/11/12, venkata kumar wrote:
> Hi,
>
> I'm venkat,
>
> I want to learn VBA. can u please let me know is there any training centers
> or working experiance t
is there a way you can add that code into one of the cells (like in , for
example k4, stating "(=if d4=d5)+(ife4=e5)+iff4=f5) and so on" of any of
those in the row 4 equal any of them in row 5...run that macro) in my
sheet, and then attach it into your reply? so I can see it in use? its
hard
Hi
Here is a code to open and print a worksheet in another workbook. You can
add your logical condition :
Sub OpenAndPrint()
Dim strPath As String
Dim wbknew As Workbook
Set wbknew = Workbooks.Open(strPath)
wbknew.ActiveSheet.PrintOut
wbknew.Close 0
End Sub
Ok. This is a very VERY crude example of what I am talking about, but it
will give you the idea. This is the sheet the factory will get every day.
The "style" that they need, the
"size" they need to make them in...how many we are making ("pcs made"), and
then how many we actually need ("pcs
Hi Asa/Domain,
So what is conclusion of this long discussion.
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Apr/Thu/2012 12:33
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Argh. Previo
Heck,
IF(ROW(),ROUND(range))
works.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Thursday, April 12, 2012 12:13 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Argh. Previously posted eva
Just got a post on the other forum that said (to his recollection) if you
Evaluate a function that doesn't expect an array argument, you have to
pursuade Evaluate to evaluate it as an array formula, such as with INDEX as
I first did, or this other suggested alternative:
IF(ROW(range),ROUND(rang
> Agree row and column is not a worksheet concept.
Not sure if this is a typo or miscommunication - I said row/column is a
worksheet concept (whatever the wisdom of my statement might be).
> But it is as you say a function of the way arrays are stored in memory.
Not row and column - but I believe
23 matches
Mail list logo
