Copy Variable to a Range of Cells

I have a situation where I declare a variable via an input box and I want that variable to be copied to a range of cells in column E. (See attached sample) However, it only needs to copy the same number of rows in column D. In the attached example, I need the variable to be inserted into cells E3:E9. If column D more rows of text then column E would mimmick the row count but insert the input data into the column.

Folowing is the code I have: (It only completes cell E3)

Please Login or Register  to view this content.

Any help would be appreciated.


Thanks,

Met

Olly:

Thank you for your response. The script you provided works. However, I failed to mention that new data will be entered into the spreadsheet and I need to retain the old values. In the sample provided, If I run the script it works great the first time. However, if I input new text into the spreadsheet(A10:D15) and run the script again, all the values in column E (E3:E) will be changed to the input variable. In the (A10:D15) case I could change the script to reflect:

Please Login or Register  to view this content.

but I do not want to modifiy my code each time. Any suggestions or help would be appreciated.


Thanks,

Met

Try the attached.

Maybe:

Please Login or Register  to view this content.

Thanks for the quick responses guys. Works great!