True, and I probably should include that warning when posting this
suggestion in the future; however, I would note that the OP indicated
nothing would be placed in the columns to be hidden, so the only place this
warning would apply is if the copied row were to be copied to a different
worksheet which might have data in those same columns that were hidden in
the source worksheet.

Rick


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Only problem with this Rick is that if OP selects a row header and Copies
that
row, even the hidden columns are included in the selection.

Although this can be overcome by first selecting the row and
F5SpecialVisible
CellsOK.

Then do the copy and paste.


Gord


On Tue, 4 Mar 2008 14:43:47 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

You could hide those columns. Select columns H through IV (you can do this
quickly by entering H:IV in the Name Box, the one to the left of the
Formula
Bar) and then right-click the selected cells and click Hide on the popup
menu that appears.

Rick


"mbnspect" wrote in message
...
I am working on an excel spread sheet. I only need to have 9 columns for
what I want to do. The columns are from A to J. Is there a way of
deleting
the rest of the columns or making them inactive. This makes it easier
especially when blocking a row. It would not be row of 702 columns but
only
of 9 columns?