![]() ![]() If Not RngToHide Is Nothing Then RngToHide. This will hide the row when the value in Col E changes to 0 Option Explicit To unhide the rows, you will have to either comment out the entire code in the Worksheet_Calculate event or change the value to a non zero value in the connected cell ( provided the connected cell in not in the hidden row). ![]() ![]() I do not recommend calling this code automatically as this will not let you unhide the rows in case you want to change something in the hidden rows. WORKSHEET CALCULATE EVENT - Not Recommended If Not RngToHide Is Nothing Then RngToHide.Hidden = True Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow ![]() You can call this code directly or use it in Worksheet_Calculate event. Click on the Home tab > click on Find & Select in ‘Editing’ section and select the Replace option in the drop-down menu. Select the Entire Data in which you want to replace Zeros with blank cells. Here is a faster method using AutoFilter. Follow the steps below to replace zeros with blanks in Excel. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |