PDA

View Full Version : Row index and first three characters in VBA



harshvardhan
04-10-2012, 04:21 AM
I have an excel spreadsheet with currency pairs USD/XYZ or XYZ/USD etc. under a particular column. I want to know the row number of the cell USD/ABC (suppose). Also, I want to know which rows have USD as the first three characters and which don't. I want to use VBA for this

Thanks for the help.