Re: Excel: Help With A Simple Macro

hmmm, not used to the macros in excel, but is there a parallel to the repeat function in the edit menu? this will do this once you have the pattern set, I.E. hide a row, move to another row, and hit control Y to do the last function to this one.


HTH,
inthane
proprietor, The Grab Bag,
for blind computer users and programmers
http://grabbag.alacorncomputer.com
Owner: Alacorn Computer Enterprises
"own the might and majesty of a Alacorn!"
www.alacorncomputer.com
Owner: Agemtree
"merchants in fine facetted and cabochon gemstones"
www.agemtree.com
----- Original Message ----- From: "Homme, James" <james.homme@xxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Tuesday, August 25, 2009 5:16 AM
Subject: Excel: Help With A Simple Macro


Hi,
How do I make a macro work on any row I happen to be on? I'm working with Excel 2007. I recorded a macro that hides the row I'm looking at. When I looked at the code, the macro had a hard-coded number for the row I was focused on. I'm sure there must be syntax that says something like select the current row and change the hide property so that it's hidden. Once I get that done, I may make one that lists hidden rows and then I can pick one I want to unhide. I may do the same thing for columns, but I have to start somewhere.

Thanks.

Jim

----------
Jim Homme
Usability Services
412-544-1810
james.homme@xxxxxxxxxxxx

"Strength does not come from physical capacity. It comes from an indomitable will." -- Mahatma Gandhi



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.
__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind



__________
View the list's information and change your settings at http://www.freelists.org/list/programmingblind

Other related posts: