Storing the value in a cell into a variable

[AndersonTO]

I'm having problems to get this done:

On a sheet named "sheet3" store the value in cell A3 into a variable called r. I'd appreciate any help or ideas.

Tks,
Anderson

 

[Joe4]

Welcome to the Board!

For what purpose? On the sheet of in VBA?

Note that on the sheet, you can use "Named Ranges".
In VBA, you can set a variable equal to a value in a particular cell, i.e.

var = Sheets("Sheet3").Range("A3")