Coding to Find Cell and Retrieve Row and Column Numbers

Excel 2010.

I have code behind an Excel workbook. How would I do the following programmatically in VBA?

1. Search the active worksheet for a particular text value in a cell?
2. Once that cell is found, determine the row and column in which it is found.

I used the macro recorder to do item 1 above, resulting in:

.Cells.Find(What:="attendance information", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate

But I do not know how to then determine (and set a variable to) to row and column numbers of the cell in which the string was found.

Any help will be greatly appreciated. Thank you.

Hi
Add the follow code line to the end of your code:

CellLocation = ActiveCell.Address

Don't forget to add Dim Cell Location at the beginning of your code.
Good luck.
Tony