Find or search error

[capngene]

If I put FIND or SEARCH in my macro, I get "SUB or FUNCTION not defined"

Please Login or Register  to view this content.

Change search to Find, get the same error.

[protonLeah]

SEARCH & FIND are worksheet functions, not VB functions. Check "Range.Find" in Help & "using Worksheet functions in VB"

[capngene]

I searched all of the help, only search and find in worksheet functions. Here is what I am trying to do. I want to get the active workbook name and call it Bookname. Then I want to delete the extension by finding the position of "." in the variable Bookname and save only the left characters to the "." less one.

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.