Hello,
I have a range of 6 columns in a worksheet where two of the columns contain
a formula that returns "" if certain columns on the same row are blank in
order to keep the worksheet looking clean.

The problem I have is that I have a macro that copies this range of cells
and then will paste specialvalues into another sheet. When I later use the
Ctrl + Down shortcut on one of teh formula columns, it seems to include the
blank cells in the paste special range as well.

How can I keep the original sheet clean and copy the data so I can delete
the rows with a "" in that particular column?

Thanks for the help,
bruce

How can