Instead, you can set the cell value equal to a string of text.
In the above examples, we set the cell value equal to a number (1). Instead of referencing a single cell, you can reference a range of cells and change all of the cell values at once: Range('A2:A5').Value = 1 Set Cell Value – Text. We'll briefly Set Multiple Cells’ Values at Once. Getting Values From Another Sheet in Excel Using VBA, Yet Excel is capable of far more than the standard editing of cell contents allows, through the magic of Visual Basic for Applications scripts, or VBA. Excel VBA set cell value in another worksheet
