Hiding Rows progamatically
 

I am using excel 2000. I receive a spreadsheet with peoples names starting
in cell a9 with a list of activity starting at c11. the activity list runs
down to c63 then another name in cell a65 and another list of activity. How
can I hide all of the rows which do not have names in them? So I can just
see the names and activity totals. Thank you in advance

David

Hiding Rows progamatically
 

select column A
Do Edit=GoTo, select special and then select only Blanks
Then do
Format=Row=Hide

If you want code, turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy


"David Bateman" wrote in message
...
I am using excel 2000. I receive a spreadsheet with peoples names starting
in cell a9 with a list of activity starting at c11. the activity list runs
down to c63 then another name in cell a65 and another list of activity.
How
can I hide all of the rows which do not have names in them? So I can just
see the names and activity totals. Thank you in advance

David