Vba to copy last 5 visible rows from autofilter range

Hi All

Have been searching without results....is there a way to copy only the last 5 visible rows after a range has been filtered.

Hi

Maybe this would work:

Copy your filtered data into a known Row

Then Select that new Data using Currentregion

Split the current region address into an array using the Split function

Adjust your array variables

Copy your required data

Deete the current region.

Please Login or Register  to view this content.

Thanks mehmetcik for your response...Seems lengthy...Nothing easier...
Will give it a go...

There may be a quicker way - but after the filter:

Please Login or Register  to view this content.

will count the visible rows - then you can find where the count is t-5
and copy from there

Hi xladept

then you can find where the count is t-5

Just can't think straight...How to do this

Subtotal 9 is the sum 3 is the countA - so something like:

Please Login or Register  to view this content.

* If that doesn't work try 103 instead of 3 as 103 excludes manually hidden rows

...Seems lengthy...Nothing easier...

How about an UDF, you don't even have to think

Please Login or Register  to view this content.

* I forgot the special cells - so:

Please Login or Register  to view this content.

@ - Karedog Thinking? What's that

@ karedog...
Perfect, thanks...
@ xladept...
Works as well...

gonna go with karedog's solution...

@Orrin,
Thinking :
It is a process to prevent the brain from rusting.

And if you ask "What is rusting ?"
It is what will happened to your brain if you stop thinking.

--------

@sintek,
You are welcome, don't forget to mark the thread as solved.

Regards