Word Find Array in Excel Spreadsheet
Hi, I am trying to open up an Excel Worksheet from within Word and then Find values from an Array then update a Document Variable from an Offset of 9 Columns to the right, but keep getting an error. What I am trying to do is update TextBox values from a Word Userform to values found in an Excel Spreadsheet by searching for a code and returning the value in the 9th column of that found value.
Please Login or Register to view this content.
For the error, remove the "." from ".Rng" throughout.
And because it's not required, also remove ".Select" from the line
Hope that helps. MM.Please Login or Register to view this content.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks