I want to select a row and insert a copy later in the worksheet

[Guest]

Please is there an easier way of copying a row with formulae containing
relative rows and insert the row elsewhere in the document

 

[Peo Sjoblom]

Easier as opposed to what, what's wrong with copy and paste?
If you want to get the same cell references don't use relative references,
use absolute or do an edit > replace, replace the equal sign with something
like ^^ or $$$$$,
copy the row, paste it somewhere else, then reverse the edit>replace and
replace ^^ with =

 

[Guest]

I do want relative addressing as the copied row is a formula template - now I
am doing the selectrow copy selectrow insert about 100 times per session.....
--
Thanks
Dennis

Easier as opposed to what, what's wrong with copy and paste?
If you want to get the same cell references don't use relative references,
use absolute or do an edit > replace, replace the equal sign with something
like ^^ or $$$$$,
copy the row, paste it somewhere else, then reverse the edit>replace and
replace ^^ with =

 

[Gord Dibben]

Post one of your formulas with cell-referencing you want to remain "relative"
and from where will you copy it and to where?


Gord Dibben MS Excel MVP