Monday, February 17, 2014

How to copy just the value of a cell (VBA-Excel)

The following macro copy just the content of a cell (A13) to another cell (B16).

Sub Copy_just_value()

Worksheets(1).Range("A13").Copy
Worksheets(2).Range("B16").PasteSpecial (xlValues)

End Sub

No comments: