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

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

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

--


Gary


"Patrick C. Simonds" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

Thank you, almost there.

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

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:(E-Mail Removed)...
> if i'm understanding what you want, maybe this:
>
> activecell.value = activecell.Offset(-1).value
>
> --
>
>
> Gary
>
>
> "Patrick C. Simonds" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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
>
>

if you really mean column "X", then:

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

--


Gary


"Patrick C. Simonds" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thank you, almost there.
>
> Now I need it to then select the cell (in the current row) in column X
>
> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
> news:(E-Mail Removed)...
>> if i'm understanding what you want, maybe this:
>>
>> activecell.value = activecell.Offset(-1).value
>>
>> --
>>
>>
>> Gary
>>
>>
>> "Patrick C. Simonds" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>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
>>
>>
>