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]