How can I create a macro that runs the same steps over and over until I stop it with CTRL+Break?

Question

How can I create a macro that runs the same steps over and over until I stop it with CTRL+Break?

Anonymous

I am trying to build aa macro but the record feature is not helping. I'd like to put my cursor in a cell on a spreadsheet, highlight 20 columns to the right, shift+end, arrow down, arrow up one row, ctrl+d and repeat this moving down the worksheet until i stop the macro. Essentially, I am filling ranges of varying lengths with the content of the first row I am highlighting (not a full row, per se, but 20 cells of the row).

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

No macro needed.

Select columns A:T, then use Ctrl-G Special..... Blanks OK Then type = press the up arrow key once, and press Ctrl-Enter. Then select columns A:T, copy them, and paste special values. And you'll be done, with the exception of the last row of data, which you can then copy and paste for as many rows as you want or need.

0 comments

3 additional answers

Answer 1

Anonymous

Thank you! This saved me hours of work.

0 comments

Answer 2

Anonymous

This is a before and after of what I am trying to achieve. There's approx 180,000 total rows that I am working to fill in.

0 comments

Answer 3

Your instructions make no sense (to me, at l;east) - or you are missing steps that you actually want.

It would be better if you showed a before and after range - and you may not be fast enough to actually control a macro with Ctrl-Break. It would be better to have some other interaction.

Share via

How can I create a macro that runs the same steps over and over until I stop it with CTRL+Break?

3 additional answers