Prev: if-then functions
Next: drop down fill in
From: pls123 on 14 May 2010 15:55
hi all !!!
let's watch this part of my sub as example..
my question is ..
is there any reason why i setted all the range as value ??
is it a lose of time and cpu undere extensive usage or
has that any reason ??? tx ! paolo

Range("D10").Value = 0
Range("L32").ClearContents
Range("E80").Value = aWS.Range("B8").Value
From: JLGWhiz on 14 May 2010 16:53
If you have a formula in the cell and do not use .Value, the results could
surprise you.



"pls123" <pls123(a)discussions.microsoft.com> wrote in message
news:ABB3F7E8-C349-4004-B946-D45DF068DA45(a)microsoft.com...
> hi all !!!
> let's watch this part of my sub as example..
> my question is ..
> is there any reason why i setted all the range as value ??
> is it a lose of time and cpu undere extensive usage or
> has that any reason ??? tx ! paolo
>
> Range("D10").Value = 0
> Range("L32").ClearContents
> Range("E80").Value = aWS.Range("B8").Value


From: USH on 14 May 2010 17:48
YES !
Tx

"JLGWhiz" wrote:

> If you have a formula in the cell and do not use .Value, the results could
> surprise you.
>
>
>
> "pls123" <pls123(a)discussions.microsoft.com> wrote in message
> news:ABB3F7E8-C349-4004-B946-D45DF068DA45(a)microsoft.com...
> > hi all !!!
> > let's watch this part of my sub as example..
> > my question is ..
> > is there any reason why i setted all the range as value ??
> > is it a lose of time and cpu undere extensive usage or
> > has that any reason ??? tx ! paolo
> >
> > Range("D10").Value = 0
> > Range("L32").ClearContents
> > Range("E80").Value = aWS.Range("B8").Value
>
>
> .
>
 | 
Pages: 1
Prev: if-then functions
Next: drop down fill in