Hide rows in multiple columns based on zero values

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Hide rows in multiple columns based on zero values

FAQ

Thread Tools

Display Modes

#14

06-18-2015, 10:37 AM

charlesdh

Windows 7 32bit Hide rows in multiple columns based on zero values

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

Hi,

Which code are you using? I believe the second code I posted will hide any row that has a "0" value. The first code I believe should only hide the row if all of the row has a value of "0".
Try the first code. If it does not work please post a copy of your file so we can see how it's formatted. You can redact vital information.

Tags

hide, rows and columns, zero values

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code to Hide columns based on selection on prior sheet	Silver1379	Excel Programming	0	04-15-2015 08:40 AM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Insert values from multiple rows based on value in one column	pachmarhi	Excel	3	07-18-2014 09:57 PM
Hide Rows and Update Chart based on cell value	ubns	Excel Programming	5	05-07-2012 05:44 AM
Conditional Formatting to Hide Rows or Columns?	sczegus	Excel	0	09-26-2006 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:59 AM.