ConfuzzledThomas
New Member
- Joined
- Nov 28, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi everyone.
I have some data in column A from row number 12 to row number 62.
I want to merge the value in each row with the cell to the right of it.
So I want to merge A12 & B12, then A13 & B13 and so on.
The code I have now doesn't generate any errors but simply doesn't do anything.
Any help appreciated
Thanks in advance, Thomas
I have some data in column A from row number 12 to row number 62.
I want to merge the value in each row with the cell to the right of it.
So I want to merge A12 & B12, then A13 & B13 and so on.
The code I have now doesn't generate any errors but simply doesn't do anything.
Any help appreciated
VBA Code:
Dim k As Long
For k = 12 To 62
Sheets("Clearance Instruction Document").Activate
Range(Cells(k, 1), Cells(k, 2)).Select
Selection.Merge
Sheets("Clearance Instruction Document").Activate
Range(Cells(k, 3), Cells(k, 4)).Select
Selection.Merge
Next k
Thanks in advance, Thomas