gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 720
- Office Version
- 2019
- Platform
- Windows
Hello,
Want to copy and paste special values in single line of vba code.
Currently Im using:
Range("K47:K48").Copy
Range("K44:K45").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Thank you
Want to copy and paste special values in single line of vba code.
Currently Im using:
Range("K47:K48").Copy
Range("K44:K45").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Thank you