Unable to set the cell value because of an invalid value or incorrect cell address.
Hi @Litsy Maria Thomas,
I hope you are trying to enter data to the Excel through Loop (For each row in excel). You can use a variable to store the Row number during each iteration and during the Set Cell action, while specifying the Cell address, specify like the Alphabet name of the Column and the Row variable.
For e.g. A$Rownumber$ (A is the Column name and Rownumber is the variable used to save current row number)If you have already followed this, could you please share the piece of code through which you are trying to mimic this action to give a better feedback?
Hi @Litsy Maria Thomas
Can you keep a message box just above the set cell command and check whether you are getting the right Cell address within the loop.
Kindly check If you use loop Counter value to set the specific cell then you have to convert to string. Please refer below screenshot.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.