GinoZ
Board Regular
- Joined
- Feb 6, 2006
- Messages
- 169
Hey guys, I have the following array
The fist column represents day. I need a VBA-code to find the last day that is filled in. Day that are not filled in have zero's as entry. n this example i want to find day 4. Some spaces are blanc.
Thanks in advance
Gino
Code:
A B C D E
1 5 A 4 5
2 6 V 5 4
3 4 6 3
4 7 W 3
5 0 0 0 0
6 0 0 0 0
The fist column represents day. I need a VBA-code to find the last day that is filled in. Day that are not filled in have zero's as entry. n this example i want to find day 4. Some spaces are blanc.
Thanks in advance
Gino