Microsoft Office Forums - View Single Post - [Solved] How to hide rows that have no data but has formula in cells?

Thread: [Solved] How to hide rows that have no data but has formula in cells?

View Single Post

Old

02-12-2018, 11:53 PM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2003

LearnerExcel uses Office 2003

Office 2003

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

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.

Reply With Quote