VBA paste as values - how to

excel vba

Transfer the values directly bypassing the clipboard.

Private Sub PasteChartDataQtyCompare()
    'This step pastes the range of values to the chart data tab
    with workSheets(1).Range("A6:J22")
        workSheets("Chart Data").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).resize(.rows.count,.columns.count) = .value
    end with
End Sub

Use Range Method "Range.PasteSpecial xlPasteValue"

Example:

Sheets("Sheet1").Columns("A").Copy
Sheets("Sheet2").Columns("B").PasteSpecial xlPasteValues

Related

Is the tangent function (like in trig) and tangent lines the same?
Question on one point compactification
The inverse of bounded operator?
Number of solns of $x^6+x=a$ in $\mathbb{F}_{2^m}$, where $m\geq 3$ is odd is same as number of solns of $x^2+ax+1=0$
Evaluating a power series
How to prove this relation between the laplacian of the logarithm and the dirac delta function?
What is the coordinate of a point $P$ on the line $2x-y+5=0$ such that $|PA-PB|$ is maximum where $A=(4,-2)$ and $B=(2,-4)$
A proof of the fact that the Fourier transform is not surjective from $\mathcal{L}^1(\mathbb{R})$ to $C_0( \mathbb{R})$
Show that only finitely many positive integers $n$ have the property that for all $m$ for which $1<m<n$ and $\text{gcd}(m,n) = 1$, $m$ is prime.
How to prove Cauchy-Schwarz integral inequality?
Integral with exp and erf
What is the minimum value of $a+b+\frac{1}{ab}$ if $a^2 + b^2 = 1$?