Sam
Someone made a good suggestion of entering the new formula in B1 then in Name
Box type B1:B60000 and ENTER then F2 and hit CTRL + ENTER.
Or you could use a macro.
Enter the new formula in B1 then run this.
Sub Auto_Fill()
Dim lrow As Long
With ActiveSheet
lrow = Range("A" & Rows.Count).End(xlUp).Row
Range("B1:B" & lrow).FillDown
End With
End Sub
Gord
On Tue, 17 May 2005 18:31:01 -0700, Sam wrote:
Hello Peo,
Put =A1 in the other cells although I can't understand why you would need the
same formula in 60000 cells!?
I meant to say what Gord said: if B1 = 100*A1, and B60000=100*A60000. If I
want to change B1 to B1=A1/C1, is there a way not to have to recopy this new
formula to cells B2:B60000?
|