CODEWITHSUNDEEP
vbaexcel
Harry Binswanger
Harry Binswanger

Reputation: 1099

VBA editor putting in a space

I'm trying to use a VBA line: 

Worksheets("Sheet6").Range("A1")

But whenever I save or Run it, the editor puts in a space, like this:

Worksheets("Sheet6).Range ("A1")

Then it won't run, I think because of the space that it added.

Or is it dumb user error?

Upvotes: 1

Views: 122

Answers (1)

Siddharth Rout
Siddharth Rout

Reputation: 149305

Yes that happens because you are doing nothing with it. 

Sub Sample()
    Worksheets("Sheet6").Range ("A1")
End Sub

Either read from it 

Sub Sample()
    Debug.Print Worksheets("Sheet6").Range("A1").Value
End Sub

or write to it 

Sub Sample()
    Worksheets("Sheet6").Range("A1").Value = "Blah Blah"
End Sub

or perform some action... 

Sub Sample()
    With Worksheets("Sheet6").Range("A1")
        '~~> Do something
    End With
End Sub

Upvotes: 4

Related Questions