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 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?