Range("G:IV").EntireColumn.Hidden = True

Or put the cursor in G1, hold down Shift+Ctrl, press the down arrow, press
the right arrow, right-click the mouse and click "Hide"

"matelot" wrote:

From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
neat thing is that he was able to show only the first dozen columns and rows
even after I do a show "row and column headers" in Options. Anyone knows how
to only show the first few rows?

Thanks