Offset Problem

[lukeois]

Hi,

I have this code below which autofilters a range and selects the data i need, there is also a small offset part that leaves the active cell as the one in the top lef of the needed data. I also have the row count of the data in cell G1. What I need to do is something along the lines of:

Please Login or Register  to view this content.

but at the same time highlighting, ready for copy, the range from where the active cell was at the start of the code below (lets say C14) to (if G1 = 7) G21, as that is where the wrong above code would get me.

Please Login or Register  to view this content.

Any help would be appreciated

Thanks

[Richard Buttrey]

Hi,

Untested without the actual workbook, but presumably:

Please Login or Register  to view this content.

HTH

[lukeois]

Richard,

That works perfectly, and simply. I had tried too many complicated ways of doing this.

Again Thanks

[Richard Buttrey]

Hi,

Thanks for the feedback Luke, and glad it's what you wanted. As I've occasionally remarked before in this and other forums, I'm constantly surprised by how much can be achieved with so little!

When you've got a spare moment please go back to the original post and mark it SOLVED - and if appropriate rate the answer (the little scales of justice icon - no I've no idea why scales )

Rgds