Paste Range to last column with data in row 10

[MattVoz]

Good evening Friends. I have a problem that I suspect will be solved easily, but I have not been able to.

I want to copy a range of cells (F12:F15) and then paste them in rows 12-15 for every column that has a value in row 10, starting at column G.

Thank you in advance for your assistance.

[bakerman2]

And how many columns would that be at max ? (otherwise we would have to loop them all )

Or try something like this.

Please Login or Register  to view this content.

[MattVoz]

Thank you for the response, we are getting close. I modified your code slightly. I changed the .Value to .Formula and Resize(3) to Resize(4). The problem is that it copies the formula as if all the cell references are absolute. I need the cell references to NOT be absolute.

The max number of columns would probably be 98.

Thanks again for your help.

[bakerman2]

how about this.

Please Login or Register  to view this content.

[MattVoz]

Thank you VERY much, that works perfectly.

[bakerman2]

Glad to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.