ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Simple Variable Question (https://www.excelbanter.com/excel-programming/283467-simple-variable-question.html)

Michael Kintner

Simple Variable Question
 
How can I set a value of a cell to a variable?

For example Cell A1 has Dog for value.

Test = Cell(A1)

Mike



Don Guillett[_4_]

Simple Variable Question
 
Test = Cell(A1)
Test = range("A1")
or
Test = [A1]

--
Don Guillett
SalesAid Software

"Michael Kintner" wrote in message
...
How can I set a value of a cell to a variable?

For example Cell A1 has Dog for value.

Test = Cell(A1)

Mike






All times are GMT +1. The time now is 12:13 PM.

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