Why not follow this procedu
1. Select the row/column you want to move and press Ctrl+X (for the
'cut' operation)
2. Go to the required place and right click on the row/column after
the point at which you want to insert
3. Select the command that says 'insert copied cells'
The row/column will be inserted, and the gap from whence it was taken
will be closed up! The same procedure can be used to transfer more
than one row/column at a time. However, when moving between sheets or
separate workbooks, the original gap will need to be deleted.
Jonathan
--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile:
http://www.excelforum.com/member.php...o&userid=17048
View this thread:
http://www.excelforum.com/showthread...hreadid=466920