Copying more decimal places using macro button and = function

[Josiah]

I have a button that uses a macro to transfer the VALUES in one range of cells on one sheet (which are all calculated using a formula) to a range of cells on a different sheet. Right now, it will only capture 2 decimal places but I need it to capture as many decimal places as are used. How can I do this?

EXAMPLE (of ONE cell in range):
Cell V84 on sheet "Paper-Ink Usage" has the formula =Y2/(1-X1) and the result is 1679.357912

MACRO (In Button) SAYS:

With Worksheets("PRICING GRID")
    .Range("Al8:Am30").Value = _
    Worksheets("Paper-Ink Usage").Range("U78:V100").Value
End With

RESULT: Corresponding value of Cell on sheet "Pricing Grid" = 1679.35 (but I WANT it to be 1679.357912)

What can I do to capture ALL decimal places? I tried adjusting decimal place values in cell formats but nothing works.

 

[Gerald Higgins]

I tried replicating this, inserting 1679.357912 into cell U78, and it copied all the decimal places to AL8.

It doesn't always SHOW all the decimal places, this was affected by column width and formatting.
But the underlying value was copied across, just as I expected.

To be clear, what value do you have in U78 ?