Run-time Error 438

[ccowman]

Hi everyone,

I'm very new to VBA and have gotten this code to work for another sheet and am basically just tweaking it for my new requirements. Wondering if anyone could help explain why I'm receiving a 438 error of "Object doesn't support this property or method". Below is my code. Thanks!

Please Login or Register  to view this content.

[Norie]

Which line of code causes the error?

[ccowman]

Sorry, wish I could say, but every time I try to Debug and "Step Into", it throws up that error. Let me know if you have any other ideas how to see which line is the issue. Thanks!

[stnkynts]

Not quite sure. It should be telling you in Visual Basic Editor which line is causing the problem. A couple things I noticed

Please Login or Register  to view this content.

Is just a single cell

Please Login or Register  to view this content.

I have a feeling this isn't going to do what you want it to do

Let us know which line of code it error on.

[ccowman]

So the code originally worked, however, it copied a few extra things that I didn't want, so I tried to tweak it. Below is the code that previously "worked". Basically, I took the code from another sheet that it worked perfectly on and tried to transform it to work for this scenario (and I don't know quite enough to fully do that properly - as you can tell).

Please Login or Register  to view this content.

I appreciate any help, but I may just re-post in the VBA forum and see if someone can help me from scratch! Thanks again!

[Norie]

I can't see anything wrong with the code and I can't test it - no worksheet/workbook/data for that.

Can you not tell us which line of code the error happens on?