Hiding Rows progamatically

  • Thread starter Thread starter David Bateman
  • Start date Start date
D

David Bateman

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro from active workbook whose name keeps changing 20
unhide cells programatically 1
Conditional listbox cell populating 4
Macro to Hide blank rows 4
Macro to hide rows below 1
Hide rows within range if B? = X 7
Combine 2 columns in a dynamic range into one 7
hiding blank rows 3

Back
Top