Range().Text line in vba generates a 424 error

[bearcub]

I understand that the text property for the Range object is a read only property. Does this mean that I can use this to paste a value in a cell though I can read a cell as text?

Are there any good articles that explain what a read only property does in VBA as opposed to a read/write property.

In other words, I can have

Range().value (value property is read/write?) = Range().text but I get a 424 error when I run this:

Range().text = Range().text

Does the text property someone change the Range object to a non-object?

Why does the 424 error not occur in the first statement ( a value to a text cell) but is pops up if I assign the text property to a text property (read only)

Thank you for your help,

Michael

 

[rlv01]

Range("A1").value is a both a read and a write property

That means you can use VBA code to read the value stored in Range("A1"), e.g.

Dim X as variant

X = Range("A1").Value

Or you can store (write) a new value to Range("A1"), e.g.

Dim X as variant

X = "Cat"
Range("A1").Value = X

Range("A1").text is a read (read-only) property, so this is legal

X = Range("A1").text

but this is not

X = "Cat"
Range("A1").Text = X