Grab the Free VBA Quick Reference Guide
[ Ссылка ]
In Excel VBA you can get the value (either Text or numbers) from a cell by referencing the cell and using .value
Code
Sub VBACells()
v = Cells(10, 2).Value
Cells(10,3) = v 'This is different than the video but more applicable
End Sub
Excel VBA Cell Value - Code Included
Теги
vba cells.valuevba cell valuevba excel cell valuevba cell with valueexcel vba cell valuevba cells valueexcel vba cells.valuecells valuecells value vbacells.value stringvba cells(x y).valueexcel vba cells(x y)cells.value excelvba cell referenceexcel vba cellsexcel vba cells syntaxvba excel cell referencemacrosvba cellsvba cells functionexcel vbavba cells addresseverydayvba