Akash030193
New Member
- Joined
- Apr 28, 2019
- Messages
- 22
I want to Merge and centre current row (row 2) with next blank row (row 3) if value is "Open". Similarly for other rows (6-7, 8-9, 10-11 etc.)
Can you please provide any suitable VBA Program?
<tbody>
</tbody>
Can you please provide any suitable VBA Program?
A | B | |
1 | Status | remark |
2 | Open | |
3 | ||
4 | Close | |
5 | Close | |
6 | Open | |
7 | ||
8 | Open | |
9 | ||
10 | Open | |
11 | ||
12 | Close |
<tbody>
</tbody>