because Location is a String Not a Range object, the .address property returns a string
and the Offset method requires a Range object. The Find method returns a Range Object, but its looking for the range (or cell) where the string "$A$7" is. You need to convert $A$7 to a range

----- Todd Huttenstine wrote: ----

Hey guy

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

Dim Locatio

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

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
Than
Tod