Hi Guys,

Please can you help me to solve my below macro problem.

I am writing a small macro.

I filtered some Value through macro.

for example A1 is visible but for example A2:A50 is hidden. Next visible row after A1 is A51. I want to select A51 through macro.

Please give a solution

Thanks