On 2002-09-20 14:02, JCScoobyRS wrote:
I need to be able to insert a row at a predetermined spot. After the row is inserted, I need to have it's first cell's value to be PROCCESSES, the second cell's value to be SET UP and the third cell's value to be PARTS. Can anyone help? Thanks, Jeremy
Hi Jeremy:
The following SUB should be added to the module of a workbook ...
Sub InsertRow1()
'
' InsertRow1 Macro
' Macro by Yogi Anand
'
' Keyboard Shortcut: Ctrl+Shift+J
'
Selection.EntireRow.Insert
ActiveCell.FormulaR1C1 = "PROCESSES"
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = "SET UP"
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = "PARTS"
ActiveCell.Offset(0, 1).Range("A1").Select
End Sub
I hope this helps.
Regards!
Yogi