How To Write To A Cell Using Excel VBA

How To Write To A Cell Using Excel VBA

Lets start from recording macro. Go to the Ribbon to the Developer tab. Click Record Marco button. Then click Edit. It will open the recorded macro as macro1 already created:

Now under this module we can learn how to write any information to a cell say cell A1 of sheet1. Here are following way we can update value in cell:

Writing to a cell using worksheet

ThisWorkbook.Sheets("Sheet1").Range("A1").Value = "hello"

Here “Sheet1” is the name of the sheet which we have used.

Run this macro:

Writing to a cell using index number of sheet

ThisWorkbook.Sheets(1).Range("A1").Value = "hello"

Here we are referencing the sheet using the index which is 1 for sheet1. We can also check the total count of sheets in a workbook using sheets.count

Writing to a cell using code name

Sheet1.Range("A1").Value = "hello"

We are directly using the sheet1 which is the sheet name here

Writing to a cell using cells

 ThisWorkbook.Sheets(1).Cells(1, 1).Value = "hello"

Instead of the range we are using cells (row no,column no) where row no = 1 for first row, column no = 1 for column A

Template

Further reading: 
Dynamic chart title from the cell 
How to hide the content of a cell in Excel? 
How to reference a cell?
Basic concepts 
Getting started with Excel
Cell References