How do you find the value of a cell in a range in VBA?

How do you find after a cell in VBA?

I'm working on a module that runs some calculations based on some text found in a cell.

The problem is, I need to find the cell it is located in and set its value.

So far, my code looks like this: Sub test(). Dim myCell As Range. Set myCell = ThisWorkbook.Worksheets("Sheet1").Range("A2")
myCell.Value = 1 End Sub. So the variable "myCell" is just empty after I run the code. How can I set the value of myCell to the current cell that my macro runs from? As suggested in the comments, you can use the following: Sub test(). Set myCell = ThisWorkbook.Worksheets("Sheet1").Range("A2")
myCell.Offset(0, -1).

How do you find the value of a cell in a range in VBA?

I have a sheet with 10 sheets that each have a value that gets multiplied.

Then that result gets placed in another cell. I'm wondering how to find that value of the resulting cell.

Eg In Cell C2 on sheet 1, the result is 1. In Sheet 4, it becomes 1. Then in Sheet 5, it becomes 1.6, etc.

I want to be able to use the code in Sheet 3 to see how much money is in that cell and then multiply it by 1.22.

Something like this (untested): 'Find the value of the current cell. Dim currentValue As Double. CurrentValue = ThisWorkbook.Worksheets("Sheet1").Cells(2, 2).