Thanks so much to both of you - you were both right. It makes sense
(though quirky) that I have to activate the sheet first to select the
cell. If I don't select the cell correctly, the variabe
varActiveCellCol which grabs the column of the active (seleted) cell is
not filled properly.

Thanks again!


--
EphesiansSix
------------------------------------------------------------------------
EphesiansSix's Profile: http://www.excelforum.com/member.php...o&userid=35721
View this thread: http://www.excelforum.com/showthread...hreadid=555046