I have found this handy doing filldowns in one column to the last row of
another column:

Range("B2", Range("A2").End(xlDown)).Offset(0, 1).FillDown

In this case, I have headers, so I start from row 2. Column A has the data
rows that I want to filldown to in column B. If column A has data to row 20,
and the word "Hello" is in B2, then the code will fill "Hello" down to B20.

Mike F
"???" wrote in message
...
Hi All,

I have an Excel database with data entry user form. In the database there
are 12 columns. One of fields is multiline and can be entered with1 to 15
database rows, while the rest of the fields are singleline. I am asking if
someone can please tell me how to autofill each entry the data for the
rest
of the lines. i have problem to define the varied range in the autofill
function.

Thanks in advance
Eli