Object Variable or with block not set

I am having an issue setting the value of a cell with some variables. I am getting the error in the post title, but I cannot find where this error is coming from.

Please Login or Register  to view this content.

Am I using too many variables for the .value part? Is this method not accepted in VBA?
Any ideas?

It's because you haven't set wsWafer to anything it is a worksheet object = Nothing at the moment. I assume you want to print the name, set the worksheet first then use wsWafer.Name

I forgot to include that part about wsWafer. There are 700+ lines in the macro and I only wanted to include the part that was relevant to the error.

Please Login or Register  to view this content.

That is with the lines declaring wsWafer. I just tried wsWafer.Name and it worked!. Thanks NigelFrost