Pages
Home
Contact Me
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment