excelmacro
Board Regular
- Joined
- Apr 8, 2002
- Messages
- 50
I have a listbox but i want to use a rowsource that isn't in the same file. how do i do this?
On 2002-04-26 08:29, excelmacro wrote:
I can't get the match formula to work. what does the 9.9999999999999E+307 do anyway?
On 2002-04-26 09:53, excelmacro wrote:
You were right. The reason it wasn't working for me is that my #'s had a ' in front of them (made all #'s have 4 digits regardless of whether they started with a 0 or not)
Did you now get the desired linking to the listbox?
On 2002-04-26 10:49, excelmacro wrote:
Did you now get the desired linking to the listbox?
It links to the correct cells and everything, but this hasn't eliminated the items in column A that repeat.
in the array column, the values that appear are the same as those in column a (duplicates still present). I'm assuming that this shouldn't be happening.
On 2002-04-26 11:07, excelmacro wrote:
I'll give you a couple of examples of them
0006BD
01448E