ExcelBanter - Put the value of a cell in a variable

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Put the value of a cell in a variable (https://www.excelbanter.com/excel-programming/307476-re-put-value-cell-variable.html)

Tom Ogilvy

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

All times are GMT +1. The time now is 06:46 PM.