Solved Determine Row selection to be hidden by value of a Cell

September 26, 2013 at 07:12:15
Specs: Windows 7
Rows("32:51").Select
Selection.EntireRow.Hidden = True

The above is two lines of instruction from a VBA
This will hide rows 32 to 51 on Sheet1

Sheet1!A52 has a COUNTIF formula that determines a value. This value is to determine the number of rows that have data in ColumnA

I have tried the following

Rows("(A52+2):51").Select
Selection.EntireRow.Hidden = True

This comes up with an error message. What am I missing?


See More: Determine Row selection to be hidden by value of a Cell

Report •

#1
September 26, 2013 at 09:27:13
✔ Best Answer
Rows(Range("E52").Value + 6 & ":51").EntireRow.Hidden = True

Answer found as above


Report •
Related Solutions


Ask Question