Assign a variable a value from cell 1

[mikej28621]

I need to Assign a variable a value from cell. Example cell A1 has 100 in it .

dim test as Integer
test= a1.value

I have looked everywhere, may have just missed it.

Thanks in advance

 

[Molby]

test=range("a1").value

 

[mikej28621]

Thank you Molby

You get a star

MJ