948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 165 - Load cell value to a vba variable

There are a few ways to do this.

value_from_range = Range("A1")

Value_from_cell = Cells(3,2)

In the above code value_from_range is a variable that gets the contents of A1 from the active sheet.

If you were to change sheets you'd get a different value.

value_from_range = [A1]

value_from_range = [Sheet1!A1]

value_from_range = sheets("Sheet1").Range("A1")

value_from_range = [='[a file name.xlsx]Sheet Name'!$A$1]

value_from_range = Workbooks("a wb.xlsx").Sheets("Sheet1").Range("A1")

You can use Cells instead

The With statement can be useful:

With Workbooks("a wb.xlsx").Sheets("Sheet1")
    .Range("A1").Select
    .Cells(3,2) = 5
    .Range(sRange) = 2
End With