Solved: Paste Range Of Cell Values From Formulas ??

[lifetree]

I'm having trouble pasting a range of cell values from a range of cells with forumlas ... could someone please make a recommendation ?? Following is the code snippet that I've been stuck on ...

Range("D1:E999").Copy
Range("D1").Select
ActiveCell.PasteSpecial (Values)

Thanks !!

[Bob Phillips]

Do you mean



With Range("D1:E999")

.Value = .Value
End With

[lifetree]

Thanks !!