MS Excel Macro with loop

Reply #3

Irvin — Sun, 27 Jun 2010 13:50:18 GMT

Alright I used the Do until loop and it works a treat.

Thank you

Reply #2

Irvin — Sun, 27 Jun 2010 11:16:26 GMT

Sorry if I am a bit vague.

I have a formula in the cell J3 which generates a random number. This number is then checked against a database. If it matches then the answer comes back true. So basically I am hitting calculate all the time until it generates a random number that comes back false. So I thought it would be easier to do a loop so it will keep calculating until false. I will try the loop function you mentioned above.

Thank you.

Reply #1

phileight — Sun, 27 Jun 2010 00:28:20 GMT

Irvin

your request is too vague to give you specific help. using Microsoft's help within Excel, can get you examples of how to use a command.

What you see below is a copy of a help page. you mentioned you were trying to use macros. for something like this you will probably have to write your macro in VBA. VBA is easy if you have done any programming or are willing to learn a few commands or statements

Do...Loop Statement Example

This example shows how Do...Loop statements can be used... [ More ]

MS Excel Macro with loop

Irvin — Sat, 26 Jun 2010 13:57:33 GMT

Hello All,

I am trying to create a macro which will loop until the specified cell comes back false.

So the cell is J3

And the function is calculate

I want it to keep recalculating until cell J3 is false.

Sorry I just dont understand macros. Any help would be appreciated.

Thanks, Irvin