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.


--
Pedros
------------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202
View this thread: http://www.excelforum.com/showthread...hreadid=564567