Copying Cell Data

After you select a range and then do a .Selection.Copy is there a way to just copy the actual DATA that is displayed to you instead of copying the formula that lies behind it?

Thanks.

Selection.PasteSpecial Paste:=xlPasteValues will do the trick

Selection.PasteSpecial Paste:=xlPasteValues will do the trick

Thanks, but I keep getting a 1004 error when i replaced that with my old paste function and try to run it.

Hmmm.

Thanks for pointing me in the right direction. Too bad xlPasteValues wasn't doing the trick for me. But at least you got me off to a good start. :p

For future reference of anyone else I used the following:


Selection.PasteSpecial Paste:=xlPasteFormats
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats


Thanks though jackson!