| Add data to cells |
 |
 |
 |
| Tutorials | |||
|
There are multiple ways to add data to worksheets cells. Below we show you a few examples. [code] Sub FillCells() '****************************************
'*** Code from VisibleVisual.com ********
'****************************************
'Add data right by using a cellname for instance cell A1
ActiveSheet.Range("A1") = "Cell A1"
'Alternative is to use the cells coordinate Cell(row, column)
ActiveSheet.Cells(3, 4) = "Cell D3" ' Cell(row, column)
'--------------------------------------------------
'To add data to a multiple collection of cells use
ActiveSheet.Range("C4:C8") = "Cell C4 - C8 "
'or use
ActiveSheet.Range("E9, E11, E13") = "Cells E9, E11, E13 "
End Sub
[/code] Download project here
|
