Re .FIND()

[David J. Braden]

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

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]

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

 

[davidm]

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


David