Is there a macro command line that I can use that will referenc
populated cells only?

My example: I have Column A populated. This may be cells A1 - A
(meaning A? = will vary). In column B, I have a macro command to ad
".

What I want to be able to do is this: run my macro and have it add th
" only those populated cells in column A.

Right now, I select cell B1 and type the formula ".
then manually copy and paste this formula to the remain cells in colum
B to the point where the cells are populated in column A. I'd like t
be able to automate this process via a macro.

Thanks!

TJ

--
Message posted from http://www.ExcelForum.com