On Dec 18, 2:36*pm, "Rick Rothstein"
wrote:
To everyone else, thank you for your time and effort.
I failed to mention that the size of each row was not
uniform. Therefore, the values from (FA1:F100)
needed to be read, individually, to set each row
to an appropriate height. A loop was the only way
I could perform this tasks.

Unless I am misunderstanding your requirements, did you read my post
*carefully*?

--
Rick (MVP - Excel)

Prior to executing the code that first hid all the rows, some of the
rows had already been hidden, as a default. The desired value of the
row height for those default hidden rows is zero.

The first set of code hides all rows between row 1 and row 90. This
includes certain rows between 1 and 90 that had been hidden as a
default.

The second set of code unhides all rows between row 1 and row 90.

After the second set of code is executed, most rows between 1 and 90
expand to their previous row height, as you stated. The rows that were
hidden, as a default prior to the execution of the first set of code,
unhide and expand to a certain height. The goal for these rows is to
set the height at zero, though. That's why I used code to loop through
all rows. Since the process is automated, my users can play with the
row heights of each row if they wish to change the size of the default
for certain rows. Consequently, they won't need to involve me in those
decisions.

Thanks for your time. I wish I had been more clear in stating my
problem.