Hi,
FIND, as called from within a wks, can be used to locate *all* occurrences
of, say, a particular string within a selection. Could someone plz tell me
how I can grab a hold on that return array from a VBA call? I am not asking
how to cycle through a selection ala Excel's help examples, but rather how
to get direct access from within VBA to what Excel returns on its wks FIND
when we request it show "all occurrences".

TIA
DaveB

I don't think you can.

It appears to be a feature missing when they enhanced the edit|find dialog.
(That and a way to clear the formats, too.)



"David J. Braden" wrote:

Hi,
FIND, as called from within a wks, can be used to locate *all* occurrences
of, say, a particular string within a selection. Could someone plz tell me
how I can grab a hold on that return array from a VBA call? I am not asking
how to cycle through a selection ala Excel's help examples, but rather how
to get direct access from within VBA to what Excel returns on its wks FIND
when we request it show "all occurrences".

TIA
DaveB

--

Dave Peterson

Thanks, Dave, for the info. Could you plz advocate that better VBA access to
FIND() is included in the next XL version?

DaveB

"Dave Peterson" wrote in message
...
I don't think you can.

It appears to be a feature missing when they enhanced the edit|find
dialog.
(That and a way to clear the formats, too.)



"David J. Braden" wrote:

Hi,
FIND, as called from within a wks, can be used to locate *all*
occurrences
of, say, a particular string within a selection. Could someone plz tell
me
how I can grab a hold on that return array from a VBA call? I am not
asking
how to cycle through a selection ala Excel's help examples, but rather
how
to get direct access from within VBA to what Excel returns on its wks
FIND
when we request it show "all occurrences".

TIA
DaveB

--

Dave Peterson

I believe it's been brought up before, but I'll ask if it's in the new version.

Ps. Have you seen this site:
http://blogs.msdn.com/excel/default.aspx

"David J. Braden" wrote:

Thanks, Dave, for the info. Could you plz advocate that better VBA access to
FIND() is included in the next XL version?

DaveB

"Dave Peterson" wrote in message
...
I don't think you can.

It appears to be a feature missing when they enhanced the edit|find
dialog.
(That and a way to clear the formats, too.)



"David J. Braden" wrote:

Hi,
FIND, as called from within a wks, can be used to locate *all*
occurrences
of, say, a particular string within a selection. Could someone plz tell
me
how I can grab a hold on that return array from a VBA call? I am not
asking
how to cycle through a selection ala Excel's help examples, but rather
how
to get direct access from within VBA to what Excel returns on its wks
FIND
when we request it show "all occurrences".

TIA
DaveB

--

Dave Peterson

--

Dave Peterson

Well done! Dave. The* blogs* link is very instructive.


David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=485639