Hi,
Why am I getting an error message here?
deleteme2.xlsx
![]()
Please Login or Register to view this content.
Hi,
Why am I getting an error message here?
deleteme2.xlsx
![]()
Please Login or Register to view this content.
You can't delete the first four lists.
Entia non sunt multiplicanda sine necessitate
Sorry, its not clear. Notice the ' before the last couple lines of code.
When trying to just add J1:J7 as a custom list I get the error, "Method 'AddCustomList' of object '_Application' failed"
You have text in those cells? That's what custom lists are made of.
No, I have numbers in those cells "J1:J7"
How can I sort column A...for example...using "J1:J7" as a custom filter?
Last edited by niko79542; 07-24-2012 at 04:37 PM.
convert the numbers (eg prefix them with an apostrophe) to text then create the list
Josie
if at first you don't succeed try doing it the way your wife told you to
Thx bro,
I didn't think of that...I kept trying to add characters at the end of the number which wasn't quite working out..Anywayz heres the correct code.
Niko
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks