Copy Paste Special Values Macro
Closed
usrvl
Posts
4
Registration date
Monday October 23, 2017
Status
Member
Last seen
October 25, 2017
-
Oct 23, 2017 at 12:17 PM
Blocked Profile - Oct 25, 2017 at 05:08 PM
Blocked Profile - Oct 25, 2017 at 05:08 PM
Related:
- Copy Paste Special Values Macro
- Facebook special characters - Guide
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Name Values - Excel Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- Copy paste e with accent - Guide
Oct 23, 2017 at 05:23 PM
Payroll # EE 1 EE 2 2
2017
1 87
2 72
3 36
4 72
5 60
6 12
7 36
8 64.5
9 72
10 61
11 60
12 24
13 60
14 36
15 49.5
16 48
17 72
18 48
19 63
20 24 72
21 0 36
22
23
24
25
26
Oct 24, 2017 at 04:38 PM
Oct 25, 2017 at 09:40 AM
'
' Macro1 Macro
' PSV
'
'
Range("B50:X50").Select
Selection.Copy
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Range("B51").Select
ActiveSheet.Paste
Range("B50:X50").Select
Application.CutCopyMode = False
Selection.Copy
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Oct 25, 2017 at 09:40 AM
Oct 25, 2017 at 05:05 PM