Re: VB and Find worksheet function

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 01/16/05 

Date: Sat, 15 Jan 2005 20:28:32 -0500

Just one additional thought, if you have coded some work*** level events,
perhaps you are getting some type of interaction between the entry of the
formula and the firing of your event code. 

-- 
Regards,
Tom Ogilvy
"Neal Zimm" <nealzimm@yahoo.com> wrote in message
news:D5CA58EC-04DF-4E88-964D-9BB74AD270CC@microsoft.com...
> Gonna beat a dead horse here, but just to make
> sure I understand, in your example:
>
> Range("b1:b200").Formula = "=Sum(C1:J1)"
>
> when the above is actually executing, I cannot
> identify, nor operate on, cell b38 easily,
> if at all.
>
> Thanks again.
> NZ
>
>
>
>
Quantcast