Find Function VBA Named Argument Not Found

I am writing a macro that runs through a word document and highlight all the values that is contained in my cell range in Excel. I have used the find function which works fine until I add the argument IgnoreSpace:= True, which I don't understand why it's resulting in error. Appreciate any help

Please Login or Register  to view this content.

I cannot find any valid way to use Range.Find in Excel the way you are using it. I am surprised it worked before you added IgnoreSpace. When I try either way I get errors.

In Excel Range.Find is a method. You are using it as though it were an object with its own methods and properties. This usage is how Range.Find is used in Word, not Excel. Can you clarify what you are doing?

It would be helpful if you could attach an Excel file that shows the way your code was without IgnoreSpace where it worked so we can run it and see what's going on.

@elyas91: please read forum rules and do not forget to add information about cross post.

https://www.mrexcel.com/board/thread.../#post-6166006

Originally Posted by KOKOSEK

@elyas91: please read forum rules and do not forget to add information about cross post.

https://www.mrexcel.com/board/thread.../#post-6166006

I appreciate your effort but please reports posts rather than attempting to moderate them yourself.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. In the thread linked above, you seem to refer (in post #6) to a third place where a solution was posted. Please provide links to all sites where you have posted this question.

To all: A solution has been posted in the cross-posted thread linked by KOKOSEK.