Microsoft Excel - Copy and paste formula values in VBA

Asked By pete r. on 01-Feb-14 11:06 AM

Hello

Be glad of some help - I created this

    Range("C48").Copy
    Range("C7").Select
    ActiveSheet.Paste
    Range("C49").Copy
    Range("C9").Select
    ActiveSheet.Paste
    Range("C50").Copy
    Range("C11").Select
    ActiveSheet.Paste

to simply copy numbers - however cells C48, C49, C50 (ones with figures to be copied) all actually contain formulas and I want the code on only copy the values. At the moment it tries to paste the formula and the cell formatting which creates a circular reference - I literally just want the value on the cells copied across.
Glad to hear back with suggestions.

Many thanks
Peter

Robbe Morris replied to pete r. on 01-Feb-14 12:01 PM

Use Excel's macro recorder to record you doing this manually. Then, take the code it generates and modify as needed.

Harry Boughen replied to pete r. on 02-Feb-14 03:16 PM

Pete a much simpler way is to use:
Range("C7").Value = Range("C48").Value
etc
Regards
Harry