Need a bit of help with this one.
Trying to write a macro that when triggered, asks the user how many times is it to be repeated and the repeats it the specified number of times.
Thanks !!
Need a bit of help with this one.
Trying to write a macro that when triggered, asks the user how many times is it to be repeated and the repeats it the specified number of times.
Thanks !!
Last edited by The Skipper; 07-03-2013 at 12:54 PM.
Hi, The Skipper,
maybe like this:
You should replace the line in the loop with what you really want the code to do - here itīs only putting date and time and the number of the loop counter to the Immediate Windiow.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks.......worked great !!
Is there a way to make the macro loop back to a specific part of the code?
Hi, Skipper,
sorry, I seem to not fully understand what you mean. Is it something like
Ciao,Please Login or Register to view this content.
Holger
The macro is quite long, and the first 13 lines of code are unique and I don't want those lines to be 'looped'. The part of the macro to be 'looped' actually begins at line 14 of the code.
Hi, Skipper,
then maybe use a boolean for the part only to be run once
Ciao,Please Login or Register to view this content.
Holger
Worked fine.........looping to correct line of code.
Thanks alot !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks