Prev: Equal list values.
Next: Just a test
From: Dave Peterson on 6 Jun 2010 06:32
With no testing at all.

Maybe you can drop the check to see if the value in column A is an "a" by moving
it into the formula. And then you could just plop the formula into all the
cells.

But this would break if you had values/formulas in those cells that need to be
kept.

Len wrote:
>
> Hi Dave,
>
> With your suggestion, It works fine
> Thanks for your advice again
>
> Is there any alternative to speed up the loop ?
>
> Regards
> Len

--

Dave Peterson
From: Don Guillett on 6 Jun 2010 09:16

I haven't followed this but there I did one recently for a client where I
had formulas such as yours referring to a defined named range which had the
workbook desired. Then a macro to change the workbook reference within the
defined name...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Len" <ltong2000mal(a)yahoo.co.uk> wrote in message
news:57205f80-d3bf-428c-88d5-7df8fc94df4c(a)s6g2000prf.googlegroups.com...
> Hi Dave,
>
> With your suggestion, It works fine
> Thanks for your advice again
>
> Is there any alternative to speed up the loop ?
>
>
> Regards
> Len

First  |  Prev  | 
Pages: 1 2 3
Prev: Equal list values.
Next: Just a test