I have a workbook and the only data in it is on Sheet1. In A1 I have the word "status". In A2 through A16 I have random text (such as banana, apple, and orange) and some of the values are duplicated/repeated in the column (in A2 through A16). I have created the below VBA code to take the unique values from this list and copy them to a new sheet. It works fine.
However, I'd like to replace the bottom most line of code with this, using Range(Cells(1, 1)), Cells(16, 1) instead of Range("A1:A16").Please Login or Register to view this content.
But it does not work and gives me an error message stating: Run-time error '1004': Method 'Range' of object '_Global' failed. Does anyone know why? Thanks.Please Login or Register to view this content.
Bookmarks