Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.winapi
|
|||
|
|||
Programming to search for a cell with certain value
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.winapi
|
|||
|
|||
Programming to search for a cell with certain value
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.winapi
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.winapi
|
|||
|
|||
Programming to search for a cell with certain value
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. "ms newsgrp" wrote in message ... : 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 : : : |
#5
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.winapi
|
|||
|
|||
Programming to search for a cell with certain value
Picky! Picky! Picky!
At least the month and day are correct... come on, let's give him SOME credit, alright?<g Rick "Randy Birch" wrote in message ... 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. "ms newsgrp" wrote in message ... : 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 : : : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell programming question | Excel Discussion (Misc queries) | |||
Programming Cell ID's | Excel Discussion (Misc queries) | |||
Programming to search for a cell with certain value | Excel Programming | |||
vba programming copy/ paste cell values help. | Excel Programming | |||
Cell value programming question | Excel Programming |