We have a program that dumps data into XLS. There are two end-user
requirements for the output. One requirement is essentially a
shortened version of the other.

To ensure that the full data set is always present it struck me that I
should be able to hide rows to create the summary. The default
version of the output will be the "short" version. The idea is that
the "expert" version would become available by unhiding the lines.

I have seen samples of code

http://www.vbaexpress.com/kb/getarticle.php?kb_id=416

with expressions like

Rows(4).EntireRow.Hidden = True

What is the simplest way to hide a mix of contiguous and contiguous
lines? ie. Hide lines 3-4, 6 ,8-22, 25 and 31. There might be 100
hidden lines in total. Does each line have to be hidden individually
or can the be treated as groups?

My VBA skills are definitely in the beginner category!

Steve