Re: Excel Question: Swapping Rows

  • From: Jacques Bosch <jfbosch@xxxxxxxxx>
  • To: programmingblind@xxxxxxxxxxxxx
  • Date: Fri, 11 Mar 2011 14:41:48 +0200

Have fun! :)
And share when you are done. :)

On Fri, Mar 11, 2011 at 2:34 PM, Homme, James <james.homme@xxxxxxxxxxxx>wrote:

> Hi Jacques,
>
> You are right. As the coffee is now coursing through my veins, I realized
> right before I read this that I could do this. Now I just need to find some
> sample VBA Excel code that checks to see if I'm on the second row or the
> last row of either a region or the sheet, and the same for columns. This
> should keep me from blabbing on the list for a little while.
>
>
>
> Thanks.
>
>
>
> Jim
>
>
>
> *From:* programmingblind-bounce@xxxxxxxxxxxxx [mailto:
> programmingblind-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jacques Bosch
> *Sent:* Friday, March 11, 2011 7:28 AM
> *To:* programmingblind@xxxxxxxxxxxxx
> *Subject:* Re: Excel Question: Swapping Rows
>
>
>
> You could probably just record a macro while doing it manually, and then
> examine the code the macro generates to see how to make it generic
> functionality. And I assume you could link the running of a macro to a hot
> key.
>
> On Fri, Mar 11, 2011 at 2:15 PM, Homme, James <james.homme@xxxxxxxxxxxx>
> wrote:
>
> Hi,
>
> I would love to be able to press one key and move a row up or down in Excel
> 2007. One key would swap with the row above. The other would swap with the
> row below. I'd like to do the same for columns. One would swap with the
> column to the right. The other would swap with the column to the left. I'd
> like to have this set of functions work for every workbook. Now for the $64
> question. How difficult is this to create, and how do you do it?
>
>
>
> Thanks.
>
>
>
> Jim
>
>
> ------------------------------
>
> This e-mail and any attachments to it are confidential and are intended
> solely for use of the individual or entity to whom they are addressed. If
> you have received this e-mail in error, please notify the sender immediately
> and then delete it. If you are not the intended recipient, you must not
> keep, use, disclose, copy or distribute this e-mail without the author's
> prior permission. The views expressed in this e-mail message do not
> necessarily represent the views of Highmark Inc., its subsidiaries, or
> affiliates.
>
>
>
>
> --
>
> Jacques Bosch
>
> Software Architecture and Development
> Independent Contractor
> Cell: +27 824711807 Fax: +27 86 504 4726
> E-Mail: jfbosch@xxxxxxxxx
>



-- 

Jacques Bosch

Software Architecture and Development
Independent Contractor
Cell: +27 824711807 Fax: +27 86 504 4726
E-Mail: jfbosch@xxxxxxxxx

Other related posts: