Range Equation

[daniel chen]

Please help, Thanks

Sub Range_equation()
Dim catalyst As Variant

Cells(1, 3) = "=""ABC""" ' as given
Cells(2, 3) = "568" ' as given

catalyst = Range("C1:C2")
Range(Cells(1, 1), Cells(2, 1)) = catalyst
catalyst = ""

' My question is why do I need a catalyst to perform the following
equation?
' Range(Cells(1, 1), Cells(2, 1)) = Range("C1:C2")
End Sub

 

[AlfD]

Hi!

I dunno: but if you use
Range(Cells(1, 1), Cells(2, 1)) = Range("C1:C2").value
it seems to work...

Al

 

[daniel chen]

Thank you, Alf
..value makes the difference
Have a nice weekend!