I'm trying to put a value into a cell in another worksheet (same workbook) without selecting that other wks.
My code below is not working...
Dim vDestRow As Integer
Dim vDestCol As Integer
vDestCol = 4
vDestRow = 114
Sheet3.Range(Cells(vDestRow, vDestCol), Cells(vDestRow, vDestCol)).Value = "XYZ"
'// this alternative line of code doesn't work either...
Sheet3.Cells(vDestRow, vDestCol).Value = "XYZ"