ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Reading a cell in VBA (https://www.excelbanter.com/new-users-excel/93327-reading-cell-vba.html)

Ruatha

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?


--
Ruatha
------------------------------------------------------------------------
Ruatha's Profile: http://www.excelforum.com/member.php...o&userid=31083
View this thread: http://www.excelforum.com/showthread...hreadid=550787


Don Guillett

Reading a cell in VBA
 
..name=range("a1").value

--
Don Guillett
SalesAid Software

"Ruatha" wrote in
message ...

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




Ruatha

Reading a cell in VBA
 

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


Don Guillett

Reading a cell in VBA
 
excel 101 but glad to help

--
Don Guillett
SalesAid Software

"Ruatha" wrote in
message ...

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





All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com