Search : in
By :

Hiding rows in Excel 2007 using macros

Last answer on Sep 21, 2009 1:43:10 am BST Younus Ali Engineer, on Sep 20, 2009 4:06:03 pm BST 
 Report this message to moderators

Hello,
i need a macro which hides rows containing blank cells in a particular column

Configuration: Windows XP professional
Safari 530.5

Best answers for « Hiding rows in Excel 2007 using macros » in :
[Excel] – Running Macro Automatically Show[Excel] – Running Macro Automatically Issue Solution Issue I have a macro in excel which needs to be run twice a day and I don’t even want to open the excel sheet. How can I make this process automatic? If I can convert the macro...
[VBA/VB6] My Documents + Environment Variables Show[VBA/VB6] My Documents + Environment Variables With VBA With VB6 Environment Functions Windows Variables Getting started As displayed in Windows Explorer, the My Documents folder appears to be in the root, but it is not the case. It...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download Excel Viewer Show
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

 venkat1926, on Sep 21, 2009 1:43:10 am BST

Try these code statements 

ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).Select
    Selection.EntireRow.Hidden = True

   
Reply to venkat1926
Ask your question Reply
They need your help