Hey guys

I cannot get the below code to work. The variable
Location currently has a value of $A$7.

Dim Location

Location = Workbooks("Completed Followup Detail
CSS.XLS").Sheets("Followup Summary").Range("A7:A3000").Find
(FindRangeA).Address
ActiveCell.Value = Location.Offset(1, 2).Value

What I want to happen is for the value of the active cell
to become the value specified in the code. For instance
currently the variable value is $A$7. I want the active
cells value to become the value of cell C8. I get this by
using my offset formula.

Instead of getting this, no value at all is being inserted.

How do I fix this?
Thanx
Todd