Hi, I have a runtime error on the following code.
The error says "Runtime error '91';
Object variable or With block variable not set.
The code looks at the value of InvRec Q7 to find the value within OutPurch C4:C25 , then copies InvRec V33:Y33 to column F on OutPurch and paste special on the same row as Q7 value from InvRec.
I have Googled the error but I do not understand vba to be able to fix it.
Please Login or Register to view this content.
Many thanks
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Many thanks for that Alphafrog that works great. Any idea why the code I was using is now caput?
You're welcome. The arguments I included for the .Find method make a difference in how it searches for a match. Probably the MatchCase:=False was the most likely correction. When using the .Find method, you should always set those argument values.
The .Find Method
Last edited by AlphaFrog; 05-08-2017 at 02:30 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks