Hello Celt,

I am glad to hear you are making good progress ...!!!
As far the last cell is concerned, if you are using xl2000, there is
sometimes a bug related to spreadsheet formatting, with the instruction
xlCellTypeLastCell, which is used to identify the "bottom end" cell.
However, with worksheets which have been extensively manipulated,
sometimes this function gets corrupted.
Two tiny recommendations :
1. Insert a new worksheet, in which you copy paste all the cells of the
worksheet you are currently using ... Then, in this newly created
worksheet hit "end" "home" to visualize where Excel jumps to ... it
should be the clean last cell ... if so ... in VB, don't forget to copy
your private modules from the old to the new worksheet and then get rid
of your old worksheet ...
2. To be on the safe side, in your macro just before the line
Selection.SpecialCells(xlCellTypeLastCell).Select
go and insert the following line
ActiveSheet.UsedRange

Go ahead and test your updated macro in your new worksheet ...
everything should be fine ...
If some reason, it does not fix your problem , do not hesitate to drop
me a line ...

HTH
Cheers
Carim

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!


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=518793

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

Thanks very much Carim!:)

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

http://www.excelforum.com/showthread...highlight=celt

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


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=518793

Hi Celt,

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

HTH
Cheers
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

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

--
Cel
-----------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...fo&userid=1941
View this thread: http://www.excelforum.com/showthread.php?threadid=51879