RE: Excel: Help With A Simple Macro
- From: "DaShiell, Jude T. CIV NAVAIR 1490, 1, 26" <jude.dashiell@xxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Tue, 25 Aug 2009 08:32:24 -0400
It's not done that way. You position the cursor where you want, then
run your macro if you give it specific rows and specific columns it goes
and works on them. If you give it named ranges then the macro works on
them.. I sit next to an excel expert who is on another project now and
that's what he just told me.
Rot47: <;F56]52D9:6==@?2GJ]>:=>
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Homme, James
Sent: Tuesday, August 25, 2009 8:16
To: programmingblind@xxxxxxxxxxxxx
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
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
