Hi Elf, Will do. Thanks to everyone for helping me create another super long thread. Jim From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of The Elf Sent: Saturday, March 12, 2011 4:28 PM To: programmingblind@xxxxxxxxxxxxx Subject: Re: Excel Question: Swapping Rows Jim when you have some useable scripts please let me know this could well be quite useful to me in some work I am doing in excel thanks, Inthane Moderator, Blind Access Help Owner: Alacorn Computer Enterprises Specialists in customized computers and peripherals - own the might and majesty of a Alacorn! www.alacorncomputer.com<http://www.alacorncomputer.com> proprietor, The Grab Bag, for blind computer users and programmers http://grabbag.alacorncomputer.com ----- Original Message ----- From: Bryan Schulz<mailto:b.schulz@xxxxxxxxxxxxx> To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx> Sent: Friday, March 11, 2011 8:06 AM Subject: Re: Excel Question: Swapping Rows hi, if this is being done somewhere in the middle and not the last two rows, you would have to do: swap row x with row y: insert a row under row y, copy row x to row z, delete row x. Bryan Schulz ----- Original Message ----- From: Homme, James<mailto:james.homme@xxxxxxxxxxxx> To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx> Sent: Friday, March 11, 2011 6:15 AM Subject: Excel Question: Swapping Rows 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.