If you use option explicit you must declare all variables which is a very
good idea but not always necessary. The really good programmers always do
it. Guess what that makes me? Anyway, thanks for the kind words.

--
Don Guillett
SalesAid Software

"Terry Pinnell" wrote in message
...
Terry Pinnell wrote:

"Don Guillett" wrote:

Pretty straight forward.
It is not using a "selection". Assumes your data to look at is in col A.
It
works from the bottom up to compare the cell above and insert a row if
they
DON'T match. If not col a, change the "a" to whatever column and the
cells(i,1) to ,2 or ,3 or ??

So it doesn't matter what is highlighted when I run it?

I'm still getting that same error message, so I assume I did something
wrong when that by now unfamiliar VBA Editor window was displayed. I
pasted it into a 'Module', as you see here.
http://www.terrypin.dial.pipex.com/Images/Macro1.gif

Success! It must have been that Option Explicit line, because after
deletion it your macro worked fine, thanks.

--
Terry, West Sussex, UK