Macro Help

[Celt]

AHHHHhhhhh!!!

That's the problem exactly. I was testing this macro on a spreadsheet
I created a year ago on XL2000. We are now using XL2003.

It works just fine now.

Thanks for all your help Carim. I truly do appreciate it!

 

[Carim]

Glad to see that you are truly enjoying your new VBA experience...
It' s a lot of fun ... and you obviously have what is needed to become
excel-lent ... !!!
All the Best

Carim

 

[Celt]

Thanks very much Carim!

Hey if you have a second, have a look at this post...

http://www.excelforum.com/showthread.php?t=522022&highlight=celt

Its another macro I am writing for the same spreadsheet. I'm having
trouble with a Text comparison argument.

 

[Carim]

Hi Celt,

Take a look at Chip's brilliant solution :
http://cpearson.com/excel/CFColors.htm

HTH
Cheers
Carim

 

[Carim]

Celt,

Before going any further ...
Replace your line :
If ActiveCell.Value = Evaluate("OR(EXACT(" & ActiveCell.Value &
",DropDown))") = False Then
by the line :
If Evaluate("OR(EXACT(" & ActiveCell.Value & ",DropDown))") Then
and see what happens ...
Tom is certainly on the most knowledgeable MVP ... !!!
Cheers
Carim

 

[Celt]

Carim,

I absolutely know Tom knows his stuff. I see his name and advic
everywhere when researching how to code in VB (and he's alway
right!!). I wouldn't dream of arguing coding with anyone on this sit
(not with my meager coding skills .

I dropped his coding in to my macro and I am getting a "type mismatch
error on a code that should return a "True" result with this functio
(ie. input exactly the same in my scanned area as it appears in th
checklist). I think that error refers to having too many elements i
my array???

I'll keep playing around with it.

Thanks for the link to the Pearson site