Copy Macro Help

Copy Macro Help

I did a record macro to copy data from one spreadsheet into another spreadsheet and it works in a way. But not the way I want it to.

Let me see if I can show it.

<iframe width="500" height="400" frameborder="0" scrolling="no" src="http://sheet.zoho.com/publish/polardude1983/copyhelp"> </iframe>


   
    
    
  1.  Sub copymenow()
    ' 
    ' copymenow Macro
    ' Created by polardude1983 on Sat, Nov 2009 05:18:28 PM
    ' 
     Range("C5").Select
     Selection.copy
     Range("D7").Select
     ActiveSheet.Paste
    End Sub








    2.

When it copies it doesn't copy the Number shown instead it copies the formula that is in that cell. I want it to copy the number instead and paste it into a different cell not the formula.