Copy Selected cells down a row with macro
 

Hello,
I'm not even sure if what I want to do is possible but here's the scenario:

I want to be able to select (highlight) multiple cells in a column, then
press a command button, and those selected cells will repeat down all the way
to the bottom of the column, no matter how many selected cells have been
selected. So if I select 2 cells containing 1-2, I want the entire column to
be 1-2-1-2-1-2-1-2,etc.. and If I select 3 cells such as 1-2-3, The entire
column should be 1-2-3-1-2-3-1-2-3.

I should also mention that I have 4 columns, and that I need the command
button to work for each of them, depending on which one I select the cells in.



How Can I do that? I've tried everything.

Thank you.:

Copy Selected cells down a row with macro
 

You have a response at your other thread.

DB33 wrote:

Hello,
I'm not even sure if what I want to do is possible but here's the scenario:

I want to be able to select (highlight) multiple cells in a column, then
press a command button, and those selected cells will repeat down all the way
to the bottom of the column, no matter how many selected cells have been
selected. So if I select 2 cells containing 1-2, I want the entire column to
be 1-2-1-2-1-2-1-2,etc.. and If I select 3 cells such as 1-2-3, The entire
column should be 1-2-3-1-2-3-1-2-3.

I should also mention that I have 4 columns, and that I need the command
button to work for each of them, depending on which one I select the cells in.

How Can I do that? I've tried everything.

Thank you.:

--

Dave Peterson