Reading a cell in VBA

[Ruatha]

Hi .
I'd like to create a filenamne wich includes the contents of a cell i
the worksheet that the button that activates the macro .
But how do I read the content of a cell from a worksheet in a VB
macro

 

[Don Guillett]

..name=range("a1").value

 

[Ruatha]

Thanx, that did it!

 

[Don Guillett]

excel 101 but glad to help