This is a text and video example of how to maniputate VBA cells:
******************************************************************
1 2 3 4 5 6 7 8 9 |
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






