Object required Run-time error '424'
Thanks.
"Gary''s Student" wrote:
Text is read-only. How about:
Sub qwerty()
Dim stl As Range, cCol As Integer
Set ctl = Range("A1")
cCol = 0
Application.ActiveCell.Offset(0, cCol).Value = ctl.Text
End Sub
--
Gary''s Student - gsnu200901
"Ayo" wrote:
I am getting the above error on the line of code:
Application.ActiveCell.Offset(0, cCol).Text = ctl.Text
and I am not sure what I am doing wrong. Any ideas?
|