Programming to search for a cell with certain value

M

ms newsgrp

I would like to be able to search for a cell with a certain string value?
Then get that cells postions. Is there a way to programmatically to do that?
Thanks
 
D

Dave Peterson

Record a macro when you do it manually and you'll see the code.

You can tweak it later.

Use Edit|Find when you're recording.
 
D

Dave Peterson

The code you use in VB will be very similar to the code inherent to VBA.

If you look at Tom Ogilvy's code for your other question, you'll see how it fits
in.
 
R

Randy Birch

Check your system date -- you're 5 years off.

--

Randy Birch
MVP Visual Basic
http://vbnet.mvps.org/
Please respond only to the newsgroups so all can benefit.


: I am not using macro. I am programming it from VB.
:
:
:
:
:
: : > Record a macro when you do it manually and you'll see the code.
: >
: > You can tweak it later.
: >
: > Use Edit|Find when you're recording.
: >
: > ms newsgrp wrote:
: > >
: > > I would like to be able to search for a cell with a certain string
: value?
: > > Then get that cells postions. Is there a way to programmatically to do
: that?
: > > Thanks
: >
: > --
: >
: > Dave Peterson
: > [email protected]
:
:
 
R

Rick Rothstein

Picky! Picky! Picky!

At least the month and day are correct... come on, let's give him SOME
credit, alright?<g>

Rick
 
Top