Adding text to end of filtered row

[johnpants]

Hi, I would like to know how to add "UpD" at the end of a row that has been filtered. The way it works is that I use autofilter to find a record, then a userform to edit the entries in that filtered row using:

Set rng = rng.SpecialCells(xlCellTypeVisible)

Now what I need to do is when I click 'Amend' I want it to add "UpD" to column P at the end of that row. It isn't a problem to do this normally, but i'm finding trouble making it work at the end of the filtered row only.

Can anyone hel pme with this?

Thanks,

John.