copy every other row

[ammartino44]

Hello. I'm trying to learn VBA. I want to copy every other row for 8 cells down starting where in the active cell. I don't want the answer to this but I would like some tips/guidance as to how to solve this myself. I think that's the key to learning VBA because I've studied quite a bit and I still can't write it.

[stnkynts]

It sounds like you are going to want to incorporate the use of a loop. A loop allows you to cycle through a certain command or code for a duration of time/quantity. There are a couple of types of loops but for your instance it sounds like you will probably want to use a For/Next loop. The loop I am thinking of has this context

Please Login or Register  to view this content.

Where "i" is the variable, start is your starting number or row in your case, finish is the end row, and counter is the frequency which you go through start to finish (i.e every 1, every other 1, every 5, etc)

Start there and report back when you get stuck

[ammartino44]

I thought I would practice by using the vba recorder and this is what I found. It doesn't help me too much haha. AND sorry I meant want to copy every other column.

Please Login or Register  to view this content.