Hi all,

just two quick questions, requiring two quick and simple answers.

I have searched the help file and tips and cannot get the answers I need:

1) what code will allow me to select the row within which the active cell is.

Eg. I have created a loop to find a certain text within a spreadsheet and once I have found that text then the cell that the text is in becomes the active cell. What code will select the row that the text is in?

2) What are the best text books available for VBA programming. I am just getting into it and would like a thorough and clear manual.

Please let me know if more infor on problem 1 is needed.

Many thanks,

Pedros.