Repeat Macro Based on Number of Cell Value

[afa18]

I am trying to repeat a macro the number of times it indicates on a cell value.

I've tried what other websites have posted with no luck.

Neither of the following 3 codes work for me. What am I doing wrong?

Please Login or Register  to view this content.

[JBeaucaire]

1) Please update your profile to list your Excel versions, not Windows 10.

2) The first macro would be the way to go. But the loop is empty. What is supposed to be done for each value of i in the loop?

[alansidman]

What do you want the macro to do. There does not seem to be any action for the macro to do other than loop.

[afa18]

I would like it to Call WRITETOTEXT.

The macro is called "WRITETOTEXT"

The cell value on Sheet4!$A$2 is 3. It is only doing it (looping) once.

[JBeaucaire]

1) Please edit your profile that it list lists your Excel Version(s), it currently states Windows 10, which is meaningless to, we need to know you Excel version(s).

2) Just because the call the macro multiple times doesn't automatically mean it won't just do the same thing 3 times, it may look no different than if it had only run once.

Please Login or Register  to view this content.

[afa18]

I updated my profile. I am using Windows Excel 2013.

[afa18]

For this Macro

Please Login or Register  to view this content.

Where would I put "Call Macro1"?

[BellyGas]

Right in between the FOR and the NEXT.

[JBeaucaire]

1) First you would always remember to put CODE tags around all posted code. My signature demonstrates how up in post #2.

I've edited your post above. Please try to remember in the future. Thanks.


2) This is often referred to as a For/Next loop, that indicates the start and end of a loop routine. Anything in between those lines IS the loop.

Look at post #5, it is demonstrated there using WRITETOTEXT instead of Macro1. Just edit that previous example as needed.

[afa18]

Ok, so Macro2() is supposed to call Macro: WRITETOTEXT
Macro WRITETOTEXT allows me to save the data in my Excel Spreadsheet onto a Notepad in my drive and then save to a folder in my network.

Please Login or Register  to view this content.

The magic is, once the notepad is saved to the folder on the network, it prints.
Therefore, I was hoping that by running this macro several times, it would print several times.

If I run WRITETOTEXT, it immediately prints. However the repeat macro Macro2() won't run WRITETOTEXT as many times as the cell value Sheet4!$A$2 indicates.

I hope this makes sense.