Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put the value of a cell in a variable
with worksheets("Sheet1")
strComp = .Range("B9").Value End With msgbox strComp -- Regards, Tom Ogilvy "SHIPP" wrote in message ... I would like to place the value of a specific cell into a variable. Does anybody know how to do this? Something like... strComp=somecells value -- M. Shipp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Cell Value | Excel Discussion (Misc queries) | |||
Adding the same cell in different worksheets. Can that cell be variable? | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
set value of variable from cell | Excel Discussion (Misc queries) | |||
Variable Not in the cell | Excel Programming |