Hi,
sheets("Int").select
Lend.Lendnm.RowSource = Range("A1:A" & lr).Address

The above code works but not the below.

Lend.Lendnm.RowSource = Sheets("Int").Range("A1:A" & lr).Address

Could anyone please help.

Thanks,
Navin.