Range Select problem

[rlkerr]

I am having a problem putting a range select statement in my macro. Here is what I'm trying to do.

I want to select E1, then count down 10 cells below and copy. My sheet is filtered, so those rows are not continues. When I do the record a macro it highlights the rows and it looks like this (e10:e506, but it's only 10 items). I only want it to count down 10 cells and copy.

Is there a statement for this.

[VBA Noob]

Think you need to select visible cells
(Manual way is to select the column > press F5 > Special > Visible cells)

The below select the cells. Change as required

Please Login or Register  to view this content.

VBA Noob

[royUK]

You don't need to Select the cells to copy them

[VBA Noob]

Agree with Roy about not needing to select. This was just an example I was playing with and should of mentioned that

VBA Noob