VBA Cells
This is a text and video example of how to maniputate VBA cells:
*************************************************************************************
Public Sub WriteToCells()
'Both of these lines of code do the same thing.
'In my opinion using the "Range" version is easier to remember...
Worksheets("Sheet1").Range("A1") = "Name"
Worksheets("Sheet1").Cells(1,1) = "Name"
End Sub
*************************************************************************************
Now watch how it's done...
That's all, I hope it helped! If not, feel free to email me at erik [at] vbahowto [dot] com
|
Are you struggling to learn VBA?
If your answer to the above question is yes, then I strongly recommend that you check out these VBA Crash Course videos |
