Hi,

I am trying to write a Macro which inserts a row below the Active Cell and then copys a pre-defined row (which contains formula's) and then pastes it into the new row.

The problem I have is that once I move away from the newly inserted row (to copy the row containing the formua's) how do I get excel to go back to the newly inserted row, as it no longer has a point of reference.

Hope someone can help

Thanks