Choice between "Compile Error" and "Error 91 - Object Variable Not Defined"

My problem has changed to getting a "Compile Error" on this line after adding the "Set" statement:

"Set qstart = Worksheets"

and without "Set", I get "Error 91 Object Variable or With Block not defined". Been on this one for better part of two days now.

If not a solution, I could use some suggestions

Please Login or Register  to view this content.

Set is how you set up object variable. If you use the set with out declaring a variable as object, you get an error, as non object variable could not be set againt a set which is an object. So, declare your variables as objects, like range, worksheet, workbook and use the set word to set up the object variable. In short, set is used with objects.

I managed to get things to work really well once I found the problem and was moving on to the next phase of my workbook.. wrapping the main subroutine (and its two called subs) into one. Stay tuned! Thanks, again, for taking the time! (And you were right, by the way.)