hi i am extremely new to vba and need some help. I have recorded a macro where i perform a search within a selected range. the code ends ".activate" when it has found the specified text. now i want to apply some formatting to the cells in that row. I am happy to use the offset function (unless there is an easier way) but how do i make it so it is applied to the active cell so i can continue with "selection." i suppose i want to make it a relative reference not "Range("A13:E13").Select
does that make sense to anyone

I would appreciate any help as i am an extreme novice who is losing confidence fast
thank
kevin

As usual, post your coding efforts for comments

--
Don Guillett
SalesAid Software

"Kevin" wrote in message
...
hi i am extremely new to vba and need some help. I have recorded a macro
where i perform a search within a selected range. the code ends ".activate"
when it has found the specified text. now i want to apply some formatting to
the cells in that row. I am happy to use the offset function (unless there
is an easier way) but how do i make it so it is applied to the active cell
so i can continue with "selection." i suppose i want to make it a relative
reference not "Range("A13:E13").Select"
does that make sense to anyone?

I would appreciate any help as i am an extreme novice who is losing
confidence fast.
thanks
kevin