Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day there Norman,
See MSKB article # 134913: XL: GetCustomListNum Returns Unexpected List Number http://support.microsoft.com/default.aspx?kbid=134913 Thanks very much for your advice. I went to the site and checked what it had to say. As it turned out, altering the index number was something I'd already tried but had no success. I rechecked everything I was doing and tried for about an hour and a half to apply the information that M'soft stated. After many, many swear words and multiple rechecking of the code, it suddenly struck me that the method may not have been the problem, but the data. I don't know what made me think of it, but on checking I found that my custom sort had turned to crap because the data I was using hadn't been validated. It was just a bunch of entries I'd typed in to give myself some sample data. Hence I was trying to sort data that wasn't recognised by my custom list!! DOH!!! Now that I've embarassed myself, and wasted hours & hours over several days, I'll move on =). Thanks once again for your assistance. Your suggestion was spot on, as that WAS one of the issues. I needed to get that correct before I was prompted to move on to check my data. See ya Ken McLennan Qld, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
More help with Custom menu's 2 problems! | Excel Programming | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Custom cell format problems | Excel Discussion (Misc queries) | |||
Custom menu problems | Excel Programming | |||
Custom function problems | Excel Programming |