Re: Excel Question: Swapping Rows

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

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

Other related posts: