B
Bob
I have a range of cell entries,
Worksheets(Sheet1Name).Range(Cells(Sheet1FirstRowNum, _
Sheet1RespCodeColPointer) & ":" & Cells(Sheet1LastRowNum, _
Sheet1RespCodeColPointer))
in which I need to:
1) count the number of unique entries and store the result in a variable
2) copy each of the unique entries that were found to an array, and then
refer to each entry in the array in a subsequent formula
Any help in showing me how to perform these 2 steps would be greatly
appreciated. Thanks.
Worksheets(Sheet1Name).Range(Cells(Sheet1FirstRowNum, _
Sheet1RespCodeColPointer) & ":" & Cells(Sheet1LastRowNum, _
Sheet1RespCodeColPointer))
in which I need to:
1) count the number of unique entries and store the result in a variable
2) copy each of the unique entries that were found to an array, and then
refer to each entry in the array in a subsequent formula
Any help in showing me how to perform these 2 steps would be greatly
appreciated. Thanks.