Find and select first #N/A cell in a filtered selection....

Thanks for pointing out :-)

I look forward to any feedback.

Please Login or Register  to view this content.

Thank you soooo much. works like a dream

I do have one last question if possible.....

Please Login or Register  to view this content.

seems to fill down but does not include last row of data.

I would like fill down to do just that until last recognised cell in range. i.e xldown up.... if there is such a command.

Thank you kindly for your time.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks bud.... spot on.