I have this code which works
When I add another worksheet to be sorted, as shown below it throws back a compile error, next without for. I'm very much a novice at vba and would really appreciate some pointers, have read various posts but can't work out why it does not work.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by BobTheRocker; 11-05-2010 at 05:16 AM.
You have too many Next ws, you only need 1 after the protection lines
The rest of your code needs tidying, you don't actually need to select sheets & rangesPlease Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If you indent you code you will see the extra "next ws" line more clearly out of sync.
You can reduce the repeated codePlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks guys, very helpful, Andy that was brilliant, everyday I learn so much from these forums. I did have to modify your code slightly to get it to work the last next had to have the ws removed.
I really need to start some serious study on compiling vba. Thank youPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks