rit_netsys
New Member
- Joined
- Jan 13, 2016
- Messages
- 8
Hello,
I need to mark consecutive more than 5 Non-Blank cells in excel like given below. It will be good if this can be done in VBA Macro.
<tbody>
</tbody>
Need help to achieve this.
I need to mark consecutive more than 5 Non-Blank cells in excel like given below. It will be good if this can be done in VBA Macro.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD |
2 | 5 | 3 | 4 | 3 | 3 | 3 | 4 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | ||||||||
1 | 2 | 3 | 4 | 5 | 6 | 5 | 7 | 7 | 8 | 8 | 7 | 6 | 5 | 4 | 3 | 4 | 6 | 6 | 6 | ||||||||||
2 | 3 | 4 | 5 | 6 | 7 | 7 | 8 | 6 | 7 | 6 | 7 | 6 | 8 | 6 | 6 | 6 | 6 | 6 | 6 |
<tbody>
</tbody>
Need help to achieve this.