Re: VB and Find work*** function

From: Neal Zimm (nealzimm_at_yahoo.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 15:43:03 -0800

re: event firing, nothing nearly that sophisticated. My b38 text was a poorly
written attempt to give an example of not being able to access an individual
cell in a 'range' execution which I should have been able to get from your
explanation. Thanks.

"Tom Ogilvy" wrote:

> 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
> >
> >
> >
> >
>
>
>