Set Cell Value as variable and the use variable in a cells calculation

[aragon123321]

Does anyone know why this does not work?
I want to set i and x as values that are entered into a cell.
I then want to use i and x in the formula for calculating another cell.
If anyone knows anything it will help out a bunch, thank you.

Dim i As Integer
Dim x As Integer
i = Range(Y8).Value
x = Range(Y9).Value
Range(Y10).Value = i * x

 

[Joe4]

You need quotes around all your range addresses, otherwise VBA thinks they are variables.
Range("Y8")

 

[aragon123321]

I am still learning how to fish ....sorry but thank you for the help. I love the calvin and hobbes picture, awesome.

 

[Joe4]

I am still learning how to fish ....sorry but thank you for the help.

You are welcome!

No need to apologize, we are here to help. We all started somewhere!