working with variables but wont add up

[barrowinfurnace]

Hi all,

I know I can use =(A1+A2) formula to add the contents of two values together.But I thought I would have a go at doing it with VBA.(not done a great deal with variables in vba)

So I wrote this code(influenced a bit by VB.net) but it just doesn't work

Sub addtwo()

Dim a as Integer
Dim b as Integer
Dim c As integer

Range("A1").Value = a
Range("A2").Value = b
Range("A3").Value = c

c = a + b.

So I place numbers in A1 and A2 on the spreadsheet but when I run the macro nothing happens.
I also tried switching things round like this:

a = Range("A1").Value

But that didn't work either.

I also gave the range it's complete address
Sheet1.Range("A1") etc....but that didn't work either.

I think my logic is near enough but I am obviously missing the point somewhere.
Any help appreciated
Barrow

[kalbasiatka]

Assign variable "a" the value of cell "A1"
a = Range("A1").Value or a = Cells(1, 1)

Please Login or Register  to view this content.

if the variables are not needed immediately to work with cells

Please Login or Register  to view this content.

[barrowinfurnace]

Many thanks for the reply and exactly what I wanted
Barrow