More reasons for not selecting cells in code, never have to worry what is
active then.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"EphesiansSix"
wrote in message
news:EphesiansSix.29vj7n_1151097902.0449@excelforu m-nospam.com...

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