+ Reply to Thread
Results 1 to 6 of 6

Move contents of selected cell down one, and to the left one cell?

  1. #1
    Albert Einstein
    Guest

    Move contents of selected cell down one, and to the left one cell?

    I am looking for a way in a macro to do the following:
    1. I select a single cell (this example C3)
    2. The contents of that cell are cut
    3. I then want to move the data down one and to the left ( this
    example B4)
    4. Then paste the contents in memory to the new cell.

    Also, I would like to make this macro available for any spreedsheet.
    What would be the best way to set it up? I am using Excel 2003.
    Thanks in advance,
    Mark

  2. #2
    Don Guillett
    Guest

    Re: Move contents of selected cell down one, and to the left one cell?

    try
    ActiveCell.Cut Destination:=ActiveCell.Offset(1, -1)


    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    "Albert Einstein" <Yomama@pleasantville.com> wrote in message
    news:083892tl0a9dmld7nj9b5cfjgunk6826h4@4ax.com...
    >I am looking for a way in a macro to do the following:
    > 1. I select a single cell (this example C3)
    > 2. The contents of that cell are cut
    > 3. I then want to move the data down one and to the left ( this
    > example B4)
    > 4. Then paste the contents in memory to the new cell.
    >
    > Also, I would like to make this macro available for any spreedsheet.
    > What would be the best way to set it up? I am using Excel 2003.
    > Thanks in advance,
    > Mark




  3. #3
    Ardus Petus
    Guest

    Re: Move contents of selected cell down one, and to the left one cell?

    With error trapping:

    With Activecell
    if .column > 1 and .row < rows.count then
    .cut destination:=.offset(1,-1)
    end if
    end with

    HTH
    --
    AP


    "Albert Einstein" <Yomama@pleasantville.com> a écrit dans le message de
    news: 083892tl0a9dmld7nj9b5cfjgunk6826h4@4ax.com...
    >I am looking for a way in a macro to do the following:
    > 1. I select a single cell (this example C3)
    > 2. The contents of that cell are cut
    > 3. I then want to move the data down one and to the left ( this
    > example B4)
    > 4. Then paste the contents in memory to the new cell.
    >
    > Also, I would like to make this macro available for any spreedsheet.
    > What would be the best way to set it up? I am using Excel 2003.
    > Thanks in advance,
    > Mark




  4. #4
    Albert Einstein
    Guest

    Re: Move contents of selected cell down one, and to the left one cell?

    This solution works great. Thanks so much for the help!

    On Sat, 17 Jun 2006 16:48:33 +0200, "Ardus Petus"
    <ardus.petus@laposte.net> wrote:

    >With error trapping:
    >
    >With Activecell
    > if .column > 1 and .row < rows.count then
    > .cut destination:=.offset(1,-1)
    > end if
    >end with
    >
    >HTH



  5. #5
    Albert Einstein
    Guest

    Re: Move contents of selected cell down one, and to the left one cell?

    This solution worked great. I appreciate your input. Have a great day.

    On Sat, 17 Jun 2006 09:32:01 -0500, "Don Guillett"
    <dguillett1@austin.rr.com> wrote:

    >try
    >ActiveCell.Cut Destination:=ActiveCell.Offset(1, -1)
    >
    >
    >Don Guillett
    >SalesAid Software
    >dguillett1@austin.rr.com
    >"Albert Einstein" <Yomama@pleasantville.com> wrote in message
    >news:083892tl0a9dmld7nj9b5cfjgunk6826h4@4ax.com...
    >>I am looking for a way in a macro to do the following:
    >> 1. I select a single cell (this example C3)
    >> 2. The contents of that cell are cut
    >> 3. I then want to move the data down one and to the left ( this
    >> example B4)
    >> 4. Then paste the contents in memory to the new cell.
    >>
    >> Also, I would like to make this macro available for any spreedsheet.
    >> What would be the best way to set it up? I am using Excel 2003.
    >> Thanks in advance,
    >> Mark

    >



  6. #6
    Don Guillett
    Guest

    Re: Move contents of selected cell down one, and to the left one cell?

    glad to help

    --
    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    "Albert Einstein" <Yomama@pleasantville.com> wrote in message
    news:4mb892tp81ire4hf4enoe9j49sf82pal3d@4ax.com...
    > This solution worked great. I appreciate your input. Have a great day.
    >
    > On Sat, 17 Jun 2006 09:32:01 -0500, "Don Guillett"
    > <dguillett1@austin.rr.com> wrote:
    >
    >>try
    >>ActiveCell.Cut Destination:=ActiveCell.Offset(1, -1)
    >>
    >>
    >>Don Guillett
    >>SalesAid Software
    >>dguillett1@austin.rr.com
    >>"Albert Einstein" <Yomama@pleasantville.com> wrote in message
    >>news:083892tl0a9dmld7nj9b5cfjgunk6826h4@4ax.com...
    >>>I am looking for a way in a macro to do the following:
    >>> 1. I select a single cell (this example C3)
    >>> 2. The contents of that cell are cut
    >>> 3. I then want to move the data down one and to the left ( this
    >>> example B4)
    >>> 4. Then paste the contents in memory to the new cell.
    >>>
    >>> Also, I would like to make this macro available for any spreedsheet.
    >>> What would be the best way to set it up? I am using Excel 2003.
    >>> Thanks in advance,
    >>> Mark

    >>

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1