View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.winapi
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Programming to search for a cell with certain value

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.



ms newsgrp wrote:

I am not using macro. I am programming it from VB.

"Dave Peterson" wrote in message
...
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


--

Dave Peterson