Is there any way to search a range of cells for a word. ie. A1:a20 I need to
find "MGNI"

Thanks,


--
Imajesty

"Imajesty" wrote in message
...
Is there any way to search a range of cells for a word. ie. A1:a20 I need
to
find "MGNI"

Thanks,


--
Imajesty

Yes, but I think you need a macro
http://msdn.microsoft.com/library/de...angeobject.asp

/Fredrik

DO you need a function to continually use or is this once? Is this for your
personal use or is this for users?

"Imajesty" wrote:

Is there any way to search a range of cells for a word. ie. A1:a20 I need to
find "MGNI"

Thanks,


--
Imajesty

I need a function that can be used from within access using vba. I've
already dimmed an excel object and have the spread sheet opened. I now need
to find a specific value in the spreadsheet, but they are concentrated in 1
row and 1 column.

Thanks, I should have been more specific.


Imajesty



"Beth" wrote:

DO you need a function to continually use or is this once? Is this for your
personal use or is this for users?

"Imajesty" wrote:

Is there any way to search a range of cells for a word. ie. A1:a20 I need to
find "MGNI"

Thanks,


--
Imajesty