Find last cell in column and copy unique records to another location on the same worksheet

[ExcelRonin]

I have used Record macro to create a macro to list the unique records in column C:C into G1

Please Login or Register  to view this content.

I would like to replace hard coded "Range("C1:C544")" with code that will look for the last cell in the column and then use that.

I've tried using;

Please Login or Register  to view this content.

This finds the last cell with data, but I am unable to make it work in the GetUnitNames() routine.

Any help appreciated

cheers

[Kaper]

embed second code into first, and you will end with

Please Login or Register  to view this content.

or shorter:

Please Login or Register  to view this content.

Btw - you use one but last cell is there a kind of total or something like it in last row? if not, remowe -1 after .End(xlUp).Row

[ExcelRonin]

Hi Kaper,
Thank you. Works as advertised.
I can see where I went wrong in define the range.
cheers