I am applying a multiply - paste special into a macro. The column that I
need to update can have anywhere from 50 to 5000 rows of numbers that
need to be updated.

If I select the whole column and then apply the paste special it inputs
a 0 if there is no value to begin with.

I tried selected the skip blanks option but that didn't help.

Thanks


--
TimmerSuds
------------------------------------------------------------------------
TimmerSuds's Profile: http://www.excelforum.com/member.php...o&userid=35596
View this thread: http://www.excelforum.com/showthread...hreadid=553732