Re: Excel: Help With A Simple Macro

  • From: "The Elf" <inthaneelf@xxxxxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Tue, 25 Aug 2009 11:44:34 -0700

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.

proprietor, The Grab Bag,
for blind computer users and programmers
Owner: Alacorn Computer Enterprises
"own the might and majesty of a Alacorn!"
Owner: Agemtree
"merchants in fine facetted and cabochon gemstones"
----- 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

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.



Jim Homme
Usability Services

"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

View the list's information and change your settings at

Other related posts: