Re: Excel Question: Swapping Rows
- From: "Dale Leavens" <dleavens@xxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 11 Mar 2011 08:05:30 -0500
There will be a variable maintained by Excel to tell you what is the last row
or column. you will be able to do the arithmetic from there. Something like
sheet.column.end I expect I'll see if I can help find it.
----- Original Message -----
From: Homme, James
To: programmingblind@xxxxxxxxxxxxx
Sent: Friday, March 11, 2011 7:34 AM
Subject: RE: Excel Question: Swapping Rows
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
Other related posts:
