first and last row not hidden

[pinguino]

hi there!!!

I'm trying to figure out the code to find the first and last cells visible in a sheet with autofilter. For example, I've a sheets filter in range A5, in such way that the rows 6 to 15 are hidden and the rows 40 and 45 are the lasts and hidden too.

So, if I ask for the first cells I should recieve 16 as answer and if I ask for the last cell the answer should be 39.

I tried:

Please Login or Register  to view this content.

but that doesn't work... Any guess??

thank you!!!!

[patel45]

attach please a sample file

[HaHoBe]

Hi, pinguino,

please adjust the range wherre the data starts (itīs in A2 for this code):

Please Login or Register  to view this content.

Absolutely no need for any workbook as a sample.

Ciao,
Holger