How can you access a cell's value via a vb variable that contains the cell's address.

I have a vb variable named cellAddress (string) that contains "$A$1" and I want to assign the contents of what cellAddress points to another VB variable - how do i Do this?

e.g. if cellAddress = "$a$1" and A1 contains "xyz", I would like to assigne "xyz" to a new vaiable by referencing just cellAddress???


Also - Can anyone reccomend a good Excel VB book? A book that maybe stresses the VB language rather then a cook-book approach. I work in an area where I can't reference the internet for help unless I go to another building so i need a good book.

Thanks,
George