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…
Let me know if you have any questions
[simple_contact_form]