range for dynamic row

[mena]

in column values
range("A1:A" & lr)

how to write this with dynamic row values


lcol = Sheets(1).Cells(1, Columns.Count).End(xlToLeft).Column
range("A1: " & lcol)


range(A1: ......" & lcol) ?????

[benishiryo]

hi mena. i supposed you mean dynamic column? you got your dynamic row correct, although you must state what you want to do with that range. for eg.

Please Login or Register  to view this content.

for a dynamic column (dependable on where column ends), try:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

of course, you also must state what you wish to do with the range

[mena]

i need to fill combobox with dynamic row values
ComboBox1.List=

[mena]

i need to fill combobox with dynamic row values