LinkBack URL
About LinkBacks
I have two identical (?) pieces of code on two different sheets (Rigs and Contractors). One is in modules, and the other in the view code on the sheet. One runs, one doesn't. I appear to have an undeclared variable but I can't see where.
I have two identical (?) pieces of code on two different sheets (Rigs and Contractors). One is in modules, and the other in the view code on the sheet. One runs, one doesn't. I appear to have an undeclared variable but I can't see where.
Last edited by BRISBANEBOB; 02-15-2014 at 09:19 PM. Reason: Solved
Hi BRISBANEBOB,
The solution to your problem is that you can't find the value "Rig" in the Header line. In this case, change the cell E8 in the sheet Rigs to "Rig" or edit the code
Cheers, berlan
Last edited by berlan; 02-15-2014 at 07:33 PM.
Hi Berlan
i have obvisouly messed up the fix. I have tried to run this from both the module and the tab but the eerror message -, Object Variable or With block variable not set'
Please Login or Register to view this content.
Try if the attached works for you
Change the E8 value to "Rig" and the code to:
Please Login or Register to view this content.
I have now succeeded in getting both pieces of code to fail! The Rigs and the Contractors won't run the sort. New sample attached
Okay, try if the attached works. Made the NewCode module more general as an alternative to use for both sheets:
Please Login or Register to view this content.
Thanks for that berlan - works beatuifully! Reputation added.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks