Trying to name an Excel range 1

[Groves22]

Hello all...
I writing a macro, and I need it to name a specific range a name. The range changes daily in length. Here is what I have:

Range(Sheets(5).Cells(6, 6).End(xlDown)).Name = "unique_producer_list"

and I get this error:
" run-time error '1004'
Method 'Range' of object '_Global' failed"

Any ideas?
Thanks!

 

[SkipVought]

hi,

Sheets(5).Cells(6, 6).End(xlDown).Name = "unique_producer_list"

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

CAVEAT: That range is ONE CELL, not the LIST.

The LIST is...

Range(Sheets(5).Cells(6, 6), Sheets(5).Cells(6, 6).End(xlDown)).Name = "unique_producer_list"

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Groves22]

Thanks Skip!