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