Copy from cell above

[Patrick C. Simonds]

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

 

[Gary Keramidas]

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

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

 

[Patrick C. Simonds]

Thank you, almost there.

Now I need it to then select the cell (in the current row) in column X

 

[Gary Keramidas]

if you really mean column "X", then:

cells(activecell.row,"X").select