Hi Jim,If you have not found the answer already replace the number of the row you are in with the following code
ActiveCell.column or ActiveCell.Row depending on whether you want to hide a row or a column. Chris----- Original Message ----- From: "Homme, James" <james.homme@xxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx> Sent: Tuesday, August 25, 2009 1:16 PM 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 //www.freelists.org/list/programmingblind__________ Information from ESET Smart Security, version of virus signature database 4365 (20090825) __________
The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4366 (20090825) __________ The message was checked by ESET Smart Security. http://www.eset.com __________View the list's information and change your settings at //www.freelists.org/list/programmingblind