Rowsource in Combo box

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.

Hi, Navin,

the following works for me

Please Login or Register  to view this content.

Ciao,
Holger

It Worked.
Thanks a ton.

Thanks,
Navin.