View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick[_17_] Rick[_17_] is offline
external usenet poster
 
Posts: 2
Default How do I make a button to PasteSpecial Values only.

I am trying to create a command button that will copy a
cells values only. Expamle:
Copy,PasteSpecial,Values: B10 to B5.
B10 has a =Sum in it and all I want to copy is the amount
in B10 to B5 and I need a button to do this.
Can anyone Help me.

Thanks
Rick