How to read a value from a cell in vba in Excel

This is a basic question but how do you read the value of a cell in VBA

Answer:

Sheets("Sheet1").Range("A1").Value

Cells(1;1).Value

(for formulas, depending on your country, you might have to change ; with , or the opposite

 Other excel answers

 

 

You can find similar Excel Questions and Answer hereunder

1) How can I get users to select a file for processing using my macro?

2) How can I get users to select a folder to save the output of my macro?

3) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

4) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

5) How to change desktop background in Excel

6) I want to pull data from a table using a reference cell in table. Is there a function to support that?

7) How to find the cell address from the column number in VBA

8) How can I extract file name from a full path including folder path and file name?

9) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

10) How can I add a WorkSheet and name it as required using VBA?

 

Here the previous and next chapter