Tushar,

This thread was last active on 11 December. OP had his date set in the
future.

--
Regards,
Tom Ogilvy

"Tushar Mehta" wrote in message
om...
You could use the Range object's Delete or Insert method with the
appropriate number of rows.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,

says...
Rather than cut and paste rows, if there a way to select a range of
cells and just move them up or down a set number of rows? (I say a
range of cells, because on some sheets each record may contain more
than one row of data) The Pseudo code below gives an idea of the
context of what I am doing. The * line is the one in question. IF cut
and paste is the best way, could you post the cut and paste method?

Compare code
IF need to move up THEN
SELECT Rows for this Record.
*MOVE SELECTED Range up or down # of rows. *
END IF