The Best Free Excel VBA Tutorials

VBA Cells

Tags: 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

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

We are a participant in the Amazon Services LLC Associates Program (and other potential affiliate networks), an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.