I'm new to Excel VBA. And now I wish to write some code using Excel VBA to search the cell position on a specific row (say row 1, not column A).
For example, row 1 contains some currency code in some uncertain positions. If I provide a currency code, say USD, and the currency code USD is located on the row 1 column Z (e.g. cell Z1). And the search can return me either 26 or Z.
How can I do this using VBA code? Please help.