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