Loops

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mbenenge@gmail.com - 11 Sep 2007 08:47 GMT

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?

Reply to this Message

Bob Phillips - 11 Sep 2007 08:53 GMT

Do what?

Signature

HTH

Bob

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

> Hi
>
[quoted text clipped - 4 lines]
> that i want to use in a separate sheet in the same workbook.
> how can i do this?

Reply to this Message

Bob I - 11 Sep 2007 13:25 GMT

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.

> Hi
>
[quoted text clipped - 4 lines]
> that i want to use in a separate sheet in the same workbook.
> how can i do this?

Reply to this Message

DS-NTE - 14 Sep 2007 05:35 GMT

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

> 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
[quoted text clipped - 9 lines]
>> that i want to use in a separate sheet in the same workbook.
>> how can i do this?

Reply to this Message

Bob I - 14 Sep 2007 18:23 GMT

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.

> Maybe this is the problem:
> OP has placed a value i A1 in every sheet and wants to use this value in his
[quoted text clipped - 16 lines]
>>>that i want to use in a separate sheet in the same workbook.
>>>how can i do this?

Reply to this Message