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
Bookmarks