Loops

[Mbenenge]

Hi

I'm learning how to use macro and at this point i'm clueless.

I am trying to perform a calculation using different values for one
veriable in my calculation. I have placed all the different values
that i want to use in a separate sheet in the same workbook.
how can i do this?

 

[Bob Phillips]

Do what?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob I]

Why would you want to assign a variable AND different values in a loop!?
Only the last value would be shown. You may wish to provide a bit more
information as to what you are trying to accomplish, rather than asking
about a particular step that doesn't make sense without the context.

 

[DS-NTE]

Maybe this is the problem:
OP has placed a value i A1 in every sheet and wants to use this value in his
calculations, maybe he uses a msgbox to display the result of each
calculation in the loop???? Just a thougt...

knut

 

[Bob I]

That's a lot of maybe's, and without a lot more specific info about what
the OP is actually trying to do, it's nothing but maybe's.