Consider there are 15000 rows in an excel and I need to search for a keyword in first column and replace the same with other keyword. How can I do this? Please suggest.
You'd need to create a new codes stage. A good way to start is to record a macro in Excel then look at the resulting VBA. The macro code cannot be pasted into the code stage, but the VBA will be similar to the VB.Net the code stage requires.
