Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2018, 10:09 PM
ganesang ganesang is offline Need to repeat macro for multiple times Windows XP Need to repeat macro for multiple times Office 2016
Competent Performer
Need to repeat macro for multiple times
 
Join Date: Jul 2018
Posts: 170
ganesang is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
ganesang: When posting code, please use the code tags and apply them to formatted code. Otherwise, your code loses much of whatever structure it had. See my edit to your original post and compare it with your post #3 in this thread.

As for the question itself, it's not apparent why you'd want to run the same macro multiple times, since the use of '.Wrap = wdFindContinue' means all instances of whatever you're trying to replace should be processed on the first execution. As it is, your code is quite inefficient; you review the code you were provided in https://www.msofficeforums.com/word-...tml#post134040 for indications as to how your code's efficiency could be improved. Consider, too, https://www.msofficeforums.com/word-...tween-two.html
Hi Paul,

Thanks for info about the code formatting. I can use it in future.



Actually, i have recorded the macro which needs to be done

Find the first set of value (using first willd card) from the end of document and cut it and replace at the first set of value (from first finding row using second wildcard) from the table.

I have recorded the macro this way, but if have 40 replacements i have to run this macro 40 times manually.

That's why asking to run macro until first wild card value false.

Please let me know if not clear.

Thanks
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to repeat macro for multiple times Mail Merge Repeat Record a certain number of times stacey_e Mail Merge 7 07-07-2023 01:27 AM
Repeat macro until no more fields ChrisJ83 Word VBA 2 01-20-2016 04:55 AM
Need to repeat macro for multiple times Print Format - Repeat Text From a Cell on Multiple Pages ChristopherHughes Excel 1 12-07-2014 08:31 PM
Need to repeat macro for multiple times How to repeat multiple .jpg's over again in Custom Slide show pbyrescue PowerPoint 1 04-03-2014 12:40 PM
Repeat formula 5 times and repeat? Jenny345 Excel 4 06-14-2013 04:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft