Please can somebody help?

I want to run a macro which starts in cell a1 and if it is not blank to
copy that cells value into another cell and print the sheet. I want
then for the macro to move down to the next non-blank cell and do the
same until it's visited all non-blank cells in the range a1:a50.

Thanks in anticipation!!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/