Can anyone help with the following problem I am facing? I am currently building some automation where I am looking for a certain string in an excel spread sheet. If found I must then look for next available empty cell in that particular row until I find an empty cell and then write to that cell.
The issue is I can’t seem to be able to increment alphabetically - so if my string is found in cell B20 I then need to check C20 and D20 etc until I find the next empty cell but how to I increment alphabetically instead of numerically? that is the only part I need help on.