One last thing (I promise), it seems my result range has to equal the total
number of cells in the inquiry. For example, if each column has 20 cells and
there are three columns, I need a results range of 60 cells, even though only
7 unique values are found/counted. Am I doing something wrong or is this
just an inherent requirement of the macro?

"Rdrummond" wrote:


Ok, now that Ihave registered and can actually see the sample
spreadsheet, the macro does what I need. I have saved a copy of it so I
can use it for the spreadhseet I am creating/modifying. Thank you so
much for the help. I know I must have frustrated the dickens out of
you. I guess it is about time for me to take the Access level 2 class
so I can get some training on macros.


--
Rdrummond
------------------------------------------------------------------------
Rdrummond's Profile: http://www.thecodecage.com/forumz/member.php?userid=92
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48582