if i'm understanding what you want, maybe this:

activecell.value = activecell.Offset(-1).value

--


Gary


"Patrick C. Simonds" wrote in message
...
I know that "Selection.End(xlToLeft).Select" will select the first cell in
the current row. What would it take to then copy the contents of the cell above
into the active cell and then select the cell (in the current row) in column X