Need to get first cell value while using Filter option through Coding

Hi

I’m using excel 2007 and where I am searching data through filter/contains by some keywords. I need VBA code for to locate first cell value which is coming under filter.
Could anyone please help me…

Looking for great solutions...

Hi Antonio,

Thanks for you quick Response... It's working for me but there is one bug if data in coming in 2nd row then it's picking next cell no like...

D1 = Header
D2 = Visible Value
D13 = Visible Value.

Ideally it should pick D2 value but it's jumping to next visible value. it's working fine with first visible more then 2 visible row. Could you please help...

Yes, you're right, my previous code was wrong, I'm sorry... you could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Great Solution!!!

Thanks a ton Antonio...