Establishing the ActiveCell as a range

**BILLONEILL40** · 06-05-2019, 05:15 PM

Working on code where I have a find element, then from that an offset to grab two numbers and total...

Please Login or Register  to view this content.

For some reason it randomly is working?

**shg** · 06-05-2019, 05:56 PM

Originally Posted by BILLONEILL40

For some reason it randomly is working?

That's good, right?

Now what?

**BILLONEILL40** · 06-05-2019, 05:59 PM

Originally Posted by shg

That's good, right?

Now what?

No that code is randomly failing.

**shg** · 06-05-2019, 06:40 PM

Failing in what way?

There are settings from the user interface that presists when you do a Find from VBA. You should set LookIn and LookAt.

Re: Establishing the ActiveCell as a range