Insert a Row at a predetermined location

[JCScoobyRS]

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

 

[Yogi Anand]

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

 

[YARNOS]

I think we have the same concerns i am writing a timesheet and i don't know were the day will finish to create the subtotal so i use one time sheet per day are we talking about the same issue email me yarnos@bigpond.com