Active cell and repeating copy and paste functionality

[nathanhamilton82]

Hello,

I can’t quite figure out the code for what I’m trying to accomplish with a dynamic copy and paste model. I’m trying to accomplish the following sequence.

1.) fill a range blue 16 cells across and 16 cells down based on the active cell that is selected.
2.) copy a range of cells from a set range that is constant.
3.) paste that range of cells based on the original active selected cell in bullet 1, but paste the item 16 cells to the right.

As you can see, the overall intent is for me to select a cell, then run the macro to erase what’s in that range of cells, then copy and paste a set range to the right of the originally selected cells. Also, any keystroke can be set up to run this macro, not set on anything.

I feel like I’m closing to coding it but I’m just too much of a novice to understand how to do so.

Thanks,
Nathan
Excel for Mac

[Mumps1]

It would be easier to help and test possible solutions if you could you attach a copy of your file? Include a detailed explanation of what you want to do using a few examples and referring to specific cells, rows, columns.

[nathanhamilton82]

Can do. Please see the attached sample file.

[Mumps1]

Try:

Please Login or Register  to view this content.

In your original post you say

erase what’s in that range of cells

The above macro doesn't erase anything it just colors it blue. If you want to erase the range, instead of coloring it blue, then use this version:

Please Login or Register  to view this content.

[nathanhamilton82]

That works. Thanks!

[Mumps1]

You are very welcome.