Identify the first cell in an autofiltered column

[gharding14]

This is probably easy, but I am having brain farts today...

I have this code.

Please Login or Register  to view this content.

I know that will simply start at A1 and Select everything to the last cell with a value.

However, I want to add an autofilter to that - select the first active cell from the filter, then to select down to the last in the filter.

I am sure it is simple, but can not find this in any macro that I have written before.

Can someone please shed some light...

THanks,

Gary Harding
Halesite, NY

[nigelbloomy]

Does this get you closer?

Please Login or Register  to view this content.

[gharding14]

Thank you Nigelbloomy. Knew it would be a simple solution.

Cheers!

Gary

[nigelbloomy]

You are welcome. Glad it was an easy fix.