|
Can a macro write a macor
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 |
Can a macro write a macor
Thanks...works well
"Rob van Gelder" wrote in message ... 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 |
| All times are GMT +1. The time now is 01:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com