Hi Folks:
How should I do this:
Coding in ThisWorkbook to count how many non-empty cells, as well as the index/position of the non-empty cells, for column D in worksheet1, workshet2, and worksheet3? Returning three integers, N1, N2, and N3 as count of non-empty, and another three integer array I1, I2, and I3, as index array;
For example:
Sheet1 collumn D
1
empty
2
empty
1
empty
2
3
1
The function should return N1 = 6, and I1 = [1 3 5 7 8 9] (assuming 1 based indexing); Thanks a lot!
Try something like this.
The three sheet counts are in the N array; N(1), N(2), N(3)
The three row arrays are in the I array (an array of arrays); I(1), I(2), I(3)
Please Login or Register to view this content.
Last edited by AlphaFrog; 11-22-2013 at 09:08 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks