VBA Cells().value is not working but range().value is working

the problem appear because the cells().value is not using (") however if you using range("").value it is mandatory for (") in parenthesis.


example :

incorrectly : Cells("26, 2").Value = "b"
Correctly : Cells(26, 2).Value = "b"

try to delete the double quotes ("") if you using cells.value

however if you using range("").value should be there double quotes ("")