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-12-2018, 11:53 PM

LearnerExcel LearnerExcel is offline

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

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

Yes it works quite fine with that file. But now I am using the same code on other Excel file changing the ranges.

Code:

For Each cl In .Range("A4:A503")

Code:

For i = 1 To 13

Columns: A to M
Rows: A4-A503

It throws that error.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02:38 AM.