Run a single row macro on multiple rows

[tomnewengland]

Hi,
I have a spreadsheet with multiple of rows containing cells with formulas. The formulas provide suggested results but we let users manually override certain cells in a row. We want to be able to let a user make changes on any rows, but if they choose they can revert the entire row back to it's original state (containing all formulas and no overrides). To do this I created a macro which copies the formulas from a control row (that nobody touches) and pastes them into a row I chose when recording the macro. How can I get it so a user can select any rows they want and run the macro to get the original formulas back?

I appreciate any input.
Here is the code from the macro:

Please Login or Register  to view this content.

[mikeTRON]

This will allow a user to select a range then hit OK.

Please Login or Register  to view this content.

[JBeaucaire]

Like so to update the current row with the original formulas:

Please Login or Register  to view this content.

[tomnewengland]

mikeTRON,
Thank you for the quick reply. Do I paste this code withing the current macro code? Is so, could you please advise where? Unfortunately, I am not very experienced in what the code means.

Thanks

[tomnewengland]

JBeaucaire,
This does exactly what I was looking for. Thank you. Is there a way with a slight tweak to the code that the user could select multiple rows before running the macro?
Thanks again

[JBeaucaire]

The user needs to select rows by selecting in column A... then this would work:

Please Login or Register  to view this content.

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

[mikeTRON]

Nice. Is there any reason you are copying and pasting instead of just spomething like this:

Please Login or Register  to view this content.

[JBeaucaire]

I didn't test, but I feared that would do strange things with relative/absolute referencing thing. I should probably test, that's a way more elegant solution if it works correctly.

[JBeaucaire]

yeah, I just tested it, that technique makes an identical copy of the original formula in the new cell, it doesn't update the relative references the way copy/paste does. Too bad.

[tomnewengland]

JBeaucaire,
The help you offered works great however one more caveat... Is there a way to make this macro work if users select multiple rows at once? Right now even with multiple rows selected, the macro only runs against the first row of the selection. Ideally it would run against all selected rows.
Here is what the current code looks like.
Thanks

Please Login or Register  to view this content.

[JBeaucaire]

Maybe this:

Please Login or Register  to view this content.

[tomnewengland]

Thanks JBeaucaire,
Appears to be working as expected. Great job!