I want to perform the equivalent of selecting a range, copying then pasting values only over the same range (to get rid of the formulae). In code, it appears easy enough as shown below. Looking at earlier forum entries, the problem appears to be fixed in an earlier version but it’s definitely not working for me. Anyone have advice?
Dim SourceRange As Range = wsAnalysis.Cells.CreateRange(“A1”, “Q20”)
Dim DestRange As Range = wsAnalysis.Cells.CreateRange(“A1”, “Q20”)