View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sam.fares@cmcsg.com is offline
external usenet poster
 
Posts: 20
Default Number of different items in an entire column without knowing if s

Thanks!

i have been able to determine the number of rows in column A that has
marks like J1,J2,.... with this code line:

LastRow = shtQDS.Range("A3").End(xlDown).Row

but i dont know how to write the syntax to tell me how many different
marks between cell A3, columnA and row"LasrRow".

I would appreciate any help with this!