VBA - Excel - Copy and Paste loop

[Gustavo Cesar]

Friends,

I need to build a loop on VBA Excel to do the following routine:

1o Action: Select entire row #1 and copy
2o Action: Select entire row #2 and Paste Special -> Formulas
3o Action: Select entire row #1 and Paste Special -> Values
4o Action: Select entire row #2 and copy
5o Action: Select entire row #3 and Paste Special -> Formulas
6o Action: Select entire row #2 and Paste Special -> Values

This routine goes on and on for an specific number of times until it reaches the end of the worksheet which may vary.
Thanks a lot for the support.

Gustavo.

[NeoPa]

Give us some more details of what you're working with Gustavo. There is very little here to work from.

[colintis]

Gustavo, do you have any attempts made so far?

As I can see it is not that hard to select, copy, and paste value/formula to specific range of cells.

[Rodney Roe]

Have you tried using record macro if you're using excell? That's how I learned how to do a lot of my vba programing.

[NeoPa]

Me too Rodney.

At least that's how I got started with any areas where I didn't already know a sensible approach. It proved a very helpful learning technique.