Arjun wrote: > Actually I was trying to copy from the source range to a new target > range starting at the current cell, as opposed to putting all the cells > into a single cell. I was under the distinct impression there is a way > to do this. Or is there a rule of sorts that a given cell in a > spreadsheet cannot cause any changes to other cells (as in, the cell > cannot actively do something to change another cell... the only way is > if the other cell refers to this cell somehow).
I can't address whether a rule exists, but I played a bit in Calc just now and I think this does what you're after: Set the first cell to reference the top left corner of the range, e.g. =Prices.A5 then grab the little black square at the bottom right of the cell and drag it down the column to A10. Then select the range A5:A10 and drag the little black square across to column G. Not sure that's what you're looking for, but either way, I just learned something new. -- Trevor --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
