supes927
07-08-2008, 01:02 AM
I'm a beginner at vba so I don't know any of the specific syntax. My task at the moment is figuring the methods that go with ActiveCell. I found that typing ActiveCell.Value = 10 shows the number 10 in the cell but when I typr ActiveCell.Text = "Hello" I get an error saying object required.
So far I only have three lines in the macro:
Sub mymsgbox()
ActiveCell.Text = "Hello"
End Sub
What constitutes an object in this situation?
So far I only have three lines in the macro:
Sub mymsgbox()
ActiveCell.Text = "Hello"
End Sub
What constitutes an object in this situation?