Reading a cell in VBA

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

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Ruatha" <Ruatha.298raz_1150035304.0289@excelforum-nospam.com> wrote in
message news:Ruatha.298raz_1150035304.0289@excelforum-nospam.com...
>
> Hi .
> I'd like to create a filenamne wich includes the contents of a cell in
> the worksheet that the button that activates the macro .
> But how do I read the content of a cell from a worksheet in a VBA
> macro?
>
>
> --
> Ruatha
> ------------------------------------------------------------------------
> Ruatha's Profile:
> http://www.excelforum.com/member.php...o&userid=31083
> View this thread: http://www.excelforum.com/showthread...hreadid=550787
>

Thanx, that did it!!

excel 101 but glad to help

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Ruatha" <Ruatha.298t5n_1150037703.6899@excelforum-nospam.com> wrote in
message news:Ruatha.298t5n_1150037703.6899@excelforum-nospam.com...
>
> Thanx, that did it!!
>
>
> --
> Ruatha
> ------------------------------------------------------------------------
> Ruatha's Profile:
> http://www.excelforum.com/member.php...o&userid=31083
> View this thread: http://www.excelforum.com/showthread...hreadid=550787
>