I wanted to do the following. I issue the find command to find a
certain text. Once found, I want to apply the cell address to a memory
variable. So the code might look this :

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

lcAddress = ????

How do I do the above.