My suggestion is to record a macro then step through the
macro (by hitting the F8 key) and watch what each line in
the macro does. To see the code click tools macro
select the macro then click the edit button. To run your
maco I also suggest you click tools macro options to
assign a "ctrl character" to run the macro insted of a
button. For a great web site on Excel macros go to
http://www.mvps.org/dmcritchie/excel/excel.htm.

Marty


-----Original Message-----
I have to apologize for my ignorance in advance. I know
nothing of VB or
embedding macros in Excel. I can learn quickly though.
Before I get to the
real question, does anyone have a suggestion for a
website that can hold my
hand through the basics of using VB macros in Excel
starting from the "I'm
an idiot" stage?

I want a macro that I can electively run on a single
sheet that will hide
all rows based on a formula I define. I'd like it to
operate based on a
button on the sheet or even just by entering the sheet.
Either is fine. I
know this is actually two or three questions in one:
1) how to initiate the macro by entering the sheet or
pressing a button
2) how to hide specific rows in a macro
3) how to use a formula in a macro (maybe not really an
issue)

Thanks all.
Scott


.