Marco / code for cell on inserted row

[mohamad]

Help
I need a macro or code to put a data cell (H14) into C column cell after inserting a row anywhere on sheet.
ie. H14 in row 16, column C, or
H14 in row 50, Column C.
Hope I explained this properly.

Thanks a bunch

( somewhere in the western desert)
mohamad

 

[fairwinds]

Maybe:

Sub xxx()
ActiveCell.EntireRow.Insert Shift:=xlDown
Cells(ActiveCell.Row, 3) = Range("H14")
End Sub

 

[al_b_cnu]

Hi,

Welcome to the board.

If I understand your requirement correctly, I think you are wanting an event to insert data when you insert a row into your spreadsheet - right?

If so (and apologies if I'm wroong), I dont know of any event which will detect the insertion of a row. Perhaps you could write a 'BeforeDoubleClick' event to actually insert the row & then insert the data into the appropriate cell i the row.

HTH

Alan