P pls123 May 14, 2010 #1 hi all !! i need the vbe command.. for insert the set of cells C80:F80 tx for help!
J JLGWhiz May 14, 2010 #3 The command is: Range("C80:F80").Insert If you want to insert complete rows, then: Range("C80").EntireRow.Insert Or Rows(80).Insert If you want the blank cells to be below row 80 then: Rows(81).Insert Because the named row is automatically shifted and the default direction is down.
The command is: Range("C80:F80").Insert If you want to insert complete rows, then: Range("C80").EntireRow.Insert Or Rows(80).Insert If you want the blank cells to be below row 80 then: Rows(81).Insert Because the named row is automatically shifted and the default direction is down.
