Macro -Copy a number a specified number of times in a column

zeemed1 · Joined: Jan 30, 2008 Posts: 1

I would like to copy a line of text (i.e. 0203) a specified number of times in a column. I have no idea how how to write a macro to do that?

Any ideas????

Thank you!

bwoody123 · Joined: Apr 25, 2007 Posts: 11

If you are only going to do it once, and just don't want to type something multiple times, I suggest using auto-fill instead of any vb code.

To Enter the same data into several cells at once:

1. Select the cells where you want to enter data. The cells do not have to be adjacent.
2. Type the data and press CTRL+ENTER.

Hope this is helpful.
Bill