S
sam.fares
Hi all:
i posted similar question before but i would like to expand on it.
i have marks(J1,J2,J3,.....) that might repeat in column A, but i would
not know the extent of how many cells in the entire column (65536)cells
will have marks in them. on some projects i might have every cell of
that column has a mark in it,and on some other projects i might have
marks in 10000 cells of that column. it depends on the project.
is there a macro that will tell me how many different marks in that
column, becuse that number will determine the number of my loops.
the way the marks are in column A is
J1
J1
J1
..
..
..
J2
J2
J2
J2
..
..
J3
J3
..
i posted similar question before but i would like to expand on it.
i have marks(J1,J2,J3,.....) that might repeat in column A, but i would
not know the extent of how many cells in the entire column (65536)cells
will have marks in them. on some projects i might have every cell of
that column has a mark in it,and on some other projects i might have
marks in 10000 cells of that column. it depends on the project.
is there a macro that will tell me how many different marks in that
column, becuse that number will determine the number of my loops.
the way the marks are in column A is
J1
J1
J1
..
..
..
J2
J2
J2
J2
..
..
J3
J3
..