Chris The Rock
Active Member
- Joined
- Feb 24, 2002
- Messages
- 287
In my code, I'm looping through a range of cells that's one row deep and 10 columns wide. The possible values in the cells are "Y" and "N".
What I want to do is create an array whose results are the column numbers of the cells in that range whose values are "Y".
For example, Values Y, N, Y, Y, N, N, N, N, Y, Y would yield the results: (1,3,4,9,10)
I'm having a tough time figuring out where to start. Can anyone help?
Thanks in advance.
What I want to do is create an array whose results are the column numbers of the cells in that range whose values are "Y".
For example, Values Y, N, Y, Y, N, N, N, N, Y, Y would yield the results: (1,3,4,9,10)
I'm having a tough time figuring out where to start. Can anyone help?
Thanks in advance.