Loop through an array

[Ricardo9211]

I am trying to setup a macro and to be honest I am lost on how to loop with an array

I have a workbook that the macro opens then goes to a specific page then pastes information. now the issue is that i have to paste in a specific Cell depending on a varCellvalue

so if the cell says
10am then paste in cell A1
2pm then paste in cell A19
6pm then paste in cell A37
10pm then paste in cell A55

I figure i would have to use a loop but if there is a more simpler way please let me know

Thanks

[JimmyA]

Hi Ricardo9211

Is there a logic to the examples you have given and are they the only options?

I stand to be corrected but if they are the only options then you could just do an "IF" in the code to paste to the correct area.

Can you upload an example?

Jim

[JBeaucaire]

I would use a SELECT CASE technique when the possible values start to increase like this:

Please Login or Register  to view this content.

[Ricardo9211]

I would love to use the case macro but when i am going to paste i am in a totally different workbook

Please Login or Register  to view this content.

[JBeaucaire]

You don't need to do all that switching back and forth and selecting. Humans manipulate data that way, VBA can address objects directly and manipulate them without selecting them first.

Please Login or Register  to view this content.

[Ricardo9211]

I see what your saying about not bouncing around but I think i have an issue with how i am inputing because i error out when it tries the
Windows("CallVolumeMacro2.xls").Range("A1:K18").Copy

I get an "object doesn't support this property or method" run-time error '438':

[Ricardo9211]

ok I got it to work i was till puttin in the varcellvalue.

works great

thanks alot

[JBeaucaire]

This is really tough with no sample sheets to test on. Try this:

Please Login or Register  to view this content.

[JBeaucaire]

Ah, good stuff! If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)