Search the cell value and Select the entire row.

[shiva_reshs]

Hello,

I need help again !

What i am trying here, is I am search a cell value which is actually a header for my data. So When I search the Data (Ctrl+F) it go to that cell, then I want the entire row of that Cell to be selected, So I can do the copy of that into another sheet?

Can we do that with macro?


Regards

[dilipandey]

HI Shiva,

yes. .. this can be done using macro. Try using below code:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

[shiva_reshs]

thanks, that what I wanted.

[dilipandey]

You are welcome shiva.. cheers


Regards,
DILIPandey

<click on below 'star' if this helps>