Hello colleagues,
I would like to ask some questions about using VBA in order to read cells in an Excel worksheets, of unknown size (rows) and then I need to read each cell value line by line.
How can I do this??
After I read each cell value line by line I have to search for a specific keyword in those lines. If that word is found then I need to perform something on that line ONLY. The action needed is to replace some keywords there
Last, I need to return everything to the cell I just read, and save that worksheet.
I need some help here on how to approach this code.
Thank-you !
Bookmarks