Actually, before someone corrects me ;)

ActiveCell.EntireColumn.SpecialCells(xlCellTypeBla nks).EntireRow.Hidden =
True

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Rob van Gelder" wrote in message
news:...
Intersect(Cells.SpecialCells(xlCellTypeBlanks),
ActiveCell.EntireColumn).EntireRow.Hidden = True

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"PCOR" wrote in message
et.cable.rogers.com...
I have a number of col and rows. Every row of every col does not
necessarily
contain data
Example:
A B C D
1 12 9 45
2 3 54
3 22 78
4 112
5 100 14
6 25 65

Using the example above: If I placed my cursor at A1 and click a button
I
want to see only rows1,2,5
If I was to press the button again(with the cursor at A1), then I would
see
the entire col again.
I would like this process to continue as I add more data to col E,F etc
Thanks in advance


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What do you mean by "show"? I assume they are already showing.

--

Vasant

"PCOR" wrote in message

et.cable.rogers.com...
I would love to have a macro do the following.
I would place my cursor at the top of a col and then press a button.
Pressing that button would do one of two things. Show all the non
blank
entries in that col or if the non entries were showiong,would show
all
the
entries in the selected col.
Can this be done
I would appreciate lots of help.
Thanks

--
Norton Professional 2004 says this email is clean...believe it