oups.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. Previously posted evaluate function
> replacing loop has unnoticed major error
>
>> Agree row and col
, April 12, 2012 12:32 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
Hi Asa/Domain,
So what is conclusion of this long discussion.
Rajan.
-Original Message-
From: excel-macros@google
excel-macros@googlegroups.com]
On Behalf Of Domain Admin
Sent: Thursday, April 12, 2012 9:16 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
I thought about that issue but discounted it beca
et only works on ranges, not arrays...
>> transpose(transpose(
>>
>> Best answer I can come up with :)
>> Asa
>>
>> -----Original Message-
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Domain Admi
array
> arrangement with the preserved data. At the cost of copying the array
> in memory twice.
>
> Asa
>
> -Original Message-----
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Wednesday, April 11, 2012 6:51 PM
> To: 'excel-macros@googlegroups.com'
&
nd
>>> transpose switches them back. So you get the original array. No idea
> why
>>> this was needed..
>>>
>>> -Original Message-----
>>> From: excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Doma
m: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Domain Admin
Sent: Wednesday, April 11, 2012 7:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
Well Holmes you&#
;
> Asa
>
> -----Original Message-
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Wednesday, April 11, 2012 6:51 PM
> To: 'excel-macros@googlegroups.com'
> Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate function
> replacing loop has u
range.Address & ",2),,1)")
>
>
>
> I used Value2 since it's usually faster, but you can use Value if you
> prefer. INDEX is the relevant change.
>
>
>
> Asa
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
&
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Wednesday, April 11, 2012 6:51 PM
> To: 'excel-macros@googlegroups.com'
> Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate function
> replacing loop has unnoticed major error
>
>> Whatever woul
ks on ranges, not arrays...
>
>> transpose(transpose(
>
>>
>
>> Best answer I can come up with :)
>
>> Asa
>
>>
>
>> -Original Message-
>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
>
etour.info]
Sent: Wednesday, April 11, 2012 6:51 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
> Whatever would make you think of it that being the case?
Sorry, makes me think
s them back. So you get the original array. No idea
> why
>>> this was needed..
>>>
>>> -Original Message-----
>>> From: excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Domain Admin
>>> Sent: We
Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Domain Admin
Sent: Wednesday, April 11, 2012 6:57 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Domain Admin
> Sent: Wednesday, April 11, 2012 6:18 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Argh. Previously posted evaluate function
> replacing loop has unnoticed major error
ros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
Whatever would make you think of it that being the case?
So if redim preserve will only let you extend the column value which
I do not get as that is almost never what any
anspose(transpose(round(a1:b10,2)))" form.
>>
>>
>>
>> From: Asa Rossoff [mailto:a...@lovetour.info]
>> Sent: Wednesday, April 11, 2012 5:18 PM
>> To: 'excel-macros@googlegroups.com'
>> Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate
pril 11, 2012 5:18 PM
> To: 'excel-macros@googlegroups.com'
> Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate function
> replacing loop has unnoticed major error
>
>
>
> Hi Howard,
>
> Seems like an Excel bug.. Sorry for not testing the suggestion.
excel-macros@googlegroups.com'
> Subject: RE: $$Excel-Macros$$ Argh. Previously posted evaluate function
> replacing loop has unnoticed major error
>
>
>
> Hi Howard,
>
> Seems like an Excel bug.. Sorry for not testing the suggestion. Evaluate
> may not be fully doc
refer. INDEX is the relevant change.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of tangledweb
Sent: Wednesday, April 11, 2012 2:28 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop
Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Domain Admin
Sent: Wednesday, April 11, 2012 5:39 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major
Value if you
>> prefer. INDEX is the relevant change.
>>
>>
>>
>> Asa
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of tangledweb
>> Sent: Wednesday, April 11, 2012 2:28 PM
>> To
>
>
> I used Value2 since it's usually faster, but you can use Value if you
> prefer. INDEX is the relevant change.
>
>
>
> Asa
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of tangledweb
> Sent: Wednesday, Apr
cel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of tangledweb
Sent: Wednesday, April 11, 2012 2:28 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Argh. Previously posted evaluate function
replacing loop has unnoticed major error
I used the evaluate
I used the evaluate function below to replace the commented out loop
portion for better performance in rounding off all the cells in a range.
It was certainly fast and it performed the round function correctly but it
also replaced every single cell in the range with the value of the first
cell (
25 matches
Mail list logo
