Copy from First Filtered Row to Last Filtered Row

[fireguy7]

Hello and thank you in advance,

I have a filtered list that I'm trying to copy just the filtered data. I need to set the range from the first filtered cell to the last and I'm having trouble tying it all together.

This is what I've tried with the attached test sheet. Setting the first filtered cell is working so I think the issue is how I'm tying the string together with the 2 set ranges. (highlighted red section)

what am I doing wrong?

Please Login or Register  to view this content.

[Arkadi]

Hi fireguy7,

How about:

Please Login or Register  to view this content.

[fireguy7]

Thanks Arkadi

still getting a compile error Object Required error. I know I'm missing one small thing the problem is finding it. Still learning so the small one offs are throwing me a bit.

[Fluff13]

This

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

[Arkadi]

@Fluff13, good call! Totally missed that.

[Fluff13]

So did I until it didn't work.

[fireguy7]

Bingo! It's always something small isn't. thanks All

[Fluff13]

Glad we could help & thanks for the feedback