J
Jeff Rider
When I copy a row, and insert the copied cells, it does not
copy the "Entire" formula of one column completely. It's
always the same column and always the same portion of the
formula ... a greater than function. The rest of the
formula seems to be fine.
I discovered that a way to get around it in Version 2002,
is simply to paste below the copied cells, as opposed to
pasting above as Excel directs you to do, by default.
This trick however does not work in 2003. Even with an
absolute reference, the formula still changes...
Any and all advice will be appreciated.
copy the "Entire" formula of one column completely. It's
always the same column and always the same portion of the
formula ... a greater than function. The rest of the
formula seems to be fine.
I discovered that a way to get around it in Version 2002,
is simply to paste below the copied cells, as opposed to
pasting above as Excel directs you to do, by default.
This trick however does not work in 2003. Even with an
absolute reference, the formula still changes...
Any and all advice will be appreciated.