Search Worksheet Function

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

MS help defines a Search Worksheet Function as
SEARCH(find_text,within_text,start_num)

But when I try to use it I get a "Undefined function "Search" in expression
error.
 
I thought the term "worksheet function" was weird too but the help I used
was within Access.
Of course I usually find that using help in any MS application is usually
worthless.

Jim Richards said:
mcl,

Use the INSTR function:

InStr([start, ]string to be searched, search string [, compare])

BTW: Worksheets are in Excel. There are no Worksheets in Access. But INSTR
Click to expand...
works both in Access and Excel.
 
In order to use MS Excel WorksheetFunctions (if they can be used at all,
some can't) in Access, you must open the Visual Basic Editor and set a
Reference to whichever Excel Object Library is available.



mcl said:
I thought the term "worksheet function" was weird too but the help I used
was within Access.
Of course I usually find that using help in any MS application is usually
worthless.

Jim Richards said:
mcl,

Use the INSTR function:

InStr([start, ]string to be searched, search string [, compare])

BTW: Worksheets are in Excel. There are no Worksheets in Access. But
Click to expand...
INSTR
works both in Access and Excel.
Hope this helps,

Jim

----- mcl wrote: -----

MS help defines a Search Worksheet Function as
SEARCH(find_text,within_text,start_num)

But when I try to use it I get a "Undefined function "Search" in expression
error.
Click to expand...
Click to expand...
 
Back
Top