Macro issue: Object variable or with block variable not set error

[utgjmb1]

I'm trying to populate a matrix from three columns in a worksheet. My code is supposed to find a value in the first column, match it to the y-axis, then search the second column for a value, match it to a column header in the x-axis, and then paste the value from the third column in the cell activated by the row/column match. Does anyone see what's wrong with my code? I keep getting a "object variable or with block variable not set" error:

I originally posted this in the general forum, but decided to move it here...Sorry I goofed on where to post it

[gjcase]

For one thing, you have several undefined variables. I suggest you use Option Explicit, and the compiler will help identify those issues.

[Leon V (AW)]

cannot test it as there are a lot of veriables used here that i am asuming are defigned elsware (e.g. originalString)
when you get the error select debug and tell us what it highlights as the problem section

as a quick fix check though use

Please Login or Register  to view this content.

[utgjmb1]

Thanks! No, they weren't defined anywhere else just because I didn't think they needed to be I'm sorry I'm a complete newbie to VBA so I'm lost. If this is the only code I have for the two worksheets below, what other variable need to be defined?

WS1.jpgWS2.jpg

[Norie]

Can we see the rest of the code?

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[utgjmb1]

Unfortunately, this is all of my code, but I'm edit my post to include the worksheets

[Norie]

What is WBook (or is it WBook1) meant to refer to?

[utgjmb1]

What is WBook (or is it WBook1) meant to refer to?

That line is accidentally in there.. you see, these worksheets are actually two different workbooks, but I combined them into one workbook manually because it was just too difficult for me to refer to them in my code, so I just gave up and started writing the code as if they were in the same workbook. I guess I'll just copy and move the worksheets so they're together every time I run this report

[Leon V (AW)]

This is basically your code and should run without errors.

Please Login or Register  to view this content.

Edit: however I can't see what it will do other than make the cell bellow activecell blank.