Hello, I have this code and I want to move test 9 so that it runs first. I still want the clear contents to run last though. Could someone please help? Thanks alot
Sorry the code is long.
Please Login or Register to view this content.
Hello, I have this code and I want to move test 9 so that it runs first. I still want the clear contents to run last though. Could someone please help? Thanks alot
Sorry the code is long.
Please Login or Register to view this content.
So why can not you run test9 first then?
Please Login or Register to view this content.
Last edited by AB33; 07-05-2014 at 03:30 PM.
Thanks AB33.
I needed to clear some of the code.
When I run what you provided sometimes it runs and sometimes it doesnt properly
would changing the clear contents to the end of the code make a difference?
Thanks
Please Login or Register to view this content.
Which one do you want to clear? Right now, you have this line ONLY
Please Login or Register to view this content.
Thats it E18 and E21
Thanks
Change the last 3 lines in to
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AB33; 07-05-2014 at 05:07 PM.
Thanks AB33
I tried the code and sub test 9 does not add data to sheet cabinet total and does not clear contents E18 and E21
I would like to remove clear content from sub test9 and put it at the very end of the code so that it runs last. I just don't know how to structure it so that it works.
Thanks
Which sub do you run first?
If posting code please use code tags, see here.
This is the code I have, i have a button that i click to run it. I want it to run all of them starting at the top.
but its not doing right.
Thanks
Please Login or Register to view this content.
Which sub does the button call first?
You need to remove all the calling codes from each sub.
Please Login or Register to view this content.
Upper
test1
test2
test3
test4
Thanks AB33. Thats Perfect.
I really Appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks