How to hide rows that have no data but has formula in cells?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to hide rows that have no data but has formula in cells?

02-13-2018, 06:31 AM

NoSparks

Windows 7 64bit How to hide rows that have no data but has formula in cells?

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Glad you figured out your error.

You might want to check things out a little further though.

Quote:

Columns: A to M
Rows: A4-A503

cl.Offset(,13) will be column N

PS: please update your profile to reflect the version of Excel you use, thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Split data in cells and duplicate rows	ballpoint	Excel Programming	6	02-07-2018 05:52 PM
eliminating blan rows between cells in a column cantaining data	FUGMAN	Excel Programming	6	03-01-2017 07:35 AM
Formula to hide '0' from blank referenced cells	formuladummy	Excel	3	05-08-2014 02:33 AM
Hide Rows	YounesB3	Excel	2	10-29-2012 05:40 AM
Sum Formula in the range with Numeric and NonNumeric data cells	Spanec	Excel	2	01-12-2012 09:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 PM.