Range Equation

D

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
 
A

AlfD

Hi!

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

Al
 
Top