Please post your macro, or at least the relative section of it..........
Vaya con Dios,
Chuck, CABGx3
"TimmerSuds" wrote:
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