Dynamic Name Range - VBA

[flexinau]

Hi,

Please, how can it be written in VBA where I want to name a range where the row number is variable. In my case, the row number should be the last row.

ps The data is contained in a column.

Thanks

 

[madineclark2001]

thank you very much ,I have some idea now for the same problem

 

[Kuntal]

Hi,
I have aproblem generating a Dynamic Range in VBA..Plz help..
I have to create a dropdown from a range, which I have done. Then another dropdown has to be populated with the same range excluding the value selected in the previous dropdown.