Method 'Range' of object'_ Worksheet' failed Error for a Label Placement

Hello all,

Can't seem to sniff this one out...highlighted line below is what is spitting out the error:

Please Login or Register  to view this content.

Example workbook is also attached.

In your sample

Please Login or Register  to view this content.

is:

Apple

so it is rather natural that

Please Login or Register  to view this content.

fails


I assume that you are trying to position your textbox relative to cells with texsts in your sheet, so I'd first search for the text:

Please Login or Register  to view this content.

PS. Please note that just fews row down you use Selection. ...
It will fail if any other than Schedule sheet is active

Thanks for your quick help Kaper. I should have been more detailed and mentioned that there are named ranges which is how the code is currently finding which row to insert/bin data, which is why referencing ws2.Range("Apple") seems to work (when the code runs as-is, everything does get plotted, but the error still occurs after).

I tried your method, and everything does plot as expected again...but the same line produces another error after running: Object variable or With block variable not set.

Thoughts?

I looked into named ranges list, and saw there no apples:

Please Login or Register  to view this content.

are sure that it is

same line produces another error

because you have another very similar line in part after

Please Login or Register  to view this content.

Hah! Problems with working with Example workbooks...The new code does take care of the error, but now is plotting more shapes than what is needed/in locations that are undesirable. I'm assuming it's something to do with the looping logic, which I'm investigating now, but maybe you know off the top of your head?

Again, attached example for reference.