Find and replace with content of cell above

[emdee]

To clean a set of data I need to replace all "XXX" entries with the content of the cell immediately above it (-1 row). Through macro recording I get the code for find&replace. But how do I refer to the content of the cell immediately above the cell in question?

 

[venkat1926]

activecell.offset(-1,0)

that means one row above same column