VBA code to adjust row height for searched cells

Hi,
I have this code to find specific text entries in a ledger. It then bolds the cell. While I have located this cell, how can I then make the row active to adjust the row height?
thanks

Please Login or Register  to view this content.

[

Try this

Please Login or Register  to view this content.

Thanks

Thank you Fredlo2010.
I set the row height to the desired height instead of the auto fit and worked.

Much appreciated.

Hi,

Change this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks

Yes, did that thanks.
Just noticed another problem,
I want the rest of the row to be centre justified, I thought I had solved this with

Please Login or Register  to view this content.

but it doesn't seem to work.

Try,

Please Login or Register  to view this content.

Ohh I like you!

Yes. Great stuff.