Creating and setting repeating objects

[keineko]

Hello,

Apologies in advance, as this explanation might sound a bit odd...would anyone know how to set a cell as an object for "x" amount of times?

For example, let's say I have a userform value of "4." Based on this value, cell A10 will be set as the first object, then A20 will be the second object, then A30 will be the third object. So something like...

Please Login or Register  to view this content.

Many thanks!

[ARowbot]

What about:

Please Login or Register  to view this content.

[keineko]

Hello, and thanks for the quick reply but I'm getting a "constant expression required" error at the Spot(i). However, intuitively, your script very much explains what I'm trying to do, and explains it much better than I did.

Thanks again, and hope you can help.

[ARowbot]

Ahh of course!

What about:

Please Login or Register  to view this content.

I'm being slightly experimental here...

[Kyle123]

You need to move the declaration out of the loop:

Please Login or Register  to view this content.

[keineko]

Hi guys,

I had to ReDim, as Kyle123 mentioned. But, when I try to go to the cell, spot(i), it always goes to cell B1, which is really odd. Any ideas?

Thanks!

[Kyle123]

when I try to go to the cell, spot(i), it always goes to cell B1

What does that mean? The code doesn't "go" anywhere?

[keineko]

Sorry about the late response and wording ambiguity. I meant that when I try to find the object, it only goes to cell B1.

For example,

Please Login or Register  to view this content.

It'll be the same for any Spot(i)...perhaps I'm using this incorrectly though...

[Kyle123]

What's spot2, what are you actually trying to do? Search the worksheet for a list of values?

[keineko]

Hello,

I guess it's sort of an odd process I'm trying to do...basically, I want to set the value of a range as an object. So there will be some text in cell A10, and that will be set as object "spot1." So everytime I'm referencing "spot1," my code knows I'm referring to the value in the text in A10. The text will be vary depending on some processes I'm running. So for example:

Please Login or Register  to view this content.