Programming to search for a cell with certain value

  • Thread starter Thread starter ms newsgrp
  • Start date Start date
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
 
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.
 
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.
 
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
: > (e-mail address removed)
:
:
 
Picky! Picky! Picky!

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

Rick
 
Back
Top