View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Paste Special question

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