change cell value in autofiltered row

[nigelog]

Seem to be going around the houses on this one

I want to change the value of the value of the first cell in an autofiltered row. There will only be one filtered entry. The first cell of the filtered row will be blank and I am trying to change it to "9TRAILER HIRE"

Please Login or Register  to view this content.

would appreciate any pointers

[Fluff13]

In what way doesn't that work?

[Fluff13]

On 2nd thoughts try

Please Login or Register  to view this content.

[nigelog]

Perfect - Thanks. Was driving me nuts LOL

[Fluff13]

Glad to help & thanks for the feedback