I have created a macro, to loop through a worksheet and create seperate worksheets based on the data. It works but after it gets to a certain point in the attached worksheet it just stops.
The worksheet is a dummy worksheet, but there are 19 sets of data on the worksheet. It stops after it copies the 9th set.
If anyone has any ideas, it would be greatly helpful.
Please Login or Register to view this content.
Last edited by Melissa9; 10-02-2012 at 12:26 PM.
I just stepped through this loop and it works when I step through it, however when I just run the macro it stops after getting so far. Any ideas would be greatly appreciated.
I've been thinking maybe this needs a timer somewhere. I think it may be running through to quickly. Please let me know if you know how to get it to wait a bit before moving on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks