How to edit cell value in VB.net - Using .Interop.Excel -
this simple question. have code: currentrow = 3 mycolumn = 2 currentcell = (currentrow & "," & mycolumn) workingsheet.cells(currentcell).value = (clientname & " " & "(" & clientlocation & ")" & " " & extradefinition) i thought place data on 'workingsheet' in position "b3" places data in cell "af1". why this? thanks, josh cell not expected used using it; have input row , column indices (as integers) separated comma. right code is: workingsheet.cells(currentrow, mycolumn).value = (clientname & " " & "(" & clientlocation & ")" & " " & extradefinition) another alternative have using range . example: workingsheet.range("b3").value = (clientname & " " & "(" & clientlocation & ")" & " " & extradefinition)