Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/gettings...
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