Copy Selected cells down a row with macro

[DB33]

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]

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