Method 'Range' of object '_Worksheet' failed

Hey,

I can't seem to figure out why this keeps giving me that error...

I've checked the row and column values inside and they seem to be ok. blank_ee() is an array of strings

Please Login or Register  to view this content.

I'm not sure what I'm missing. Seems like it should be a simple problem, but I can't seem to find it.

Thanks for all your help.

Hello Kaigi,

The array blank-ee has to return a string variable that represents an Excel worksheet address, like "A1:G50".

Thanks for the tip. I do believe that is the case though...

blank_ee(1...3) = "$I:$16", "$I:$17", and "$I:$75" respectively.

All the .row and .column calls seem to give what I expect so I don't understand why I'm still getting this error.

One thing I've seem to notice is that sometimes, after fiddling with the line a bit (but not actually changing anything) it works. But then I go to run it again and the error comes back. Any ideas on why that might happen?

I suspect you want:

Please Login or Register  to view this content.

Assuming your code was in a normal module, then it would only have worked when ws5 was the active sheet. In this code:

Please Login or Register  to view this content.

the red parts are not qualified with a worksheet object. In the With...End With construct I posted, you will see they are preceded by a period which makes them properties of the ws5 object.

Yes, you should qualify all properties/methods really unless you are sure the default behaviour is what you want (even then it might change in future versions!)
Incidentally, if the code had been in a worksheet code module, those red highlighted words would have referred to the worksheet containing the code, not (necessarily) the active sheet or the sheet you wanted.