Having an issue during my ForEachRow activity. I have successfully captured the text I want via GetText (I used a message box to confirm and each time it looped a new message box with the info popped up) and assigned it a variable. What I now want to do is input that data into the same row but in a different column.
I tried using WriteCell using “Sheets1” - row(2) and then the variable for the input. It kept throwing an error “Option Strict On disallows implicit conversions from ‘Object’ to ‘String’” so I tried row(2).ToString, still no effect.
Thanks in advance!