S
serdar
Range("c5") = Range("a1").Address
puts,
$A$1
to c5. How to put,
A1
to c5?
puts,
$A$1
to c5. How to put,
A1
to c5?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KL
Range("c5") = Range("a1").Address(0,0)
Regards,
KL
Regards,
KL
S
serdar
Great!
haber iletisinde þunlarý said:Range("c5") = Range("a1").Address(0,0)
Regards,
KL
S
serdar
Why should i use:
Range("A11?).Formula
when i can write:
Range("c5") = "=" & Range("a1").Address(0, 0) & "+" &
Range("a2").Address(0, 0)
Range("A11?).Formula
when i can write:
Range("c5") = "=" & Range("a1").Address(0, 0) & "+" &
Range("a2").Address(0, 0)
K
KL
You don't have to. As you have already noticed it will work with the Value
property (if no property specified for a range it is Value by default)
Regards,
KL
property (if no property specified for a range it is Value by default)
Regards,
KL