| 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 | |||
Linear Mode
