Hello there,
Ok you folks probably were too busy to tackle the above macro. No matter. Anyway thats been resolved.
May i request for your time and knowledge in editting this small macro ? would be immensely grateful.
this macro does the following
insert row 2 in sheet 2 (only on sheet two , ie not on all sheets of the workbook)
copy paste row 1 onto row 2 of sheet two
(repeat every 75 minutes. It doesnt open, save or close the workbook)
HTML Code:
Sub insert_row()
Selection.Insert Shift:=xlDown
Copy ([row1])
Paste ([row2])
End Sub
but after pasting cell1 the macro gives a 400 error.
can u kindly help with the macro
thanks in advance