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 
  To: 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.

Other related posts: