To repeat an answer earlier today
In a word, there is no way to get the recorder to do that.
The macro can do what you want though, you just have to modify it to do so.
For instance, to find a value, use Find
Set cell = a_specified_range.Find("value")
and then to offset it use
If Not cell Is Nothing Then
cell.Offset(2,6).Select
etc.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
