Hi,
There's an excel files, 100 thousand rows and 71columns, I used the "Circle Invalid data" found all Invalid data,but it's a big problem and difficult for me to find all "Circle Invalid data" in this sheet, how can i get all the "Circle Invalid data" location messages, output all location messages in other sheet and use the hyperlinks mark them.
In other words, I need get the Invalid data's row and column's message
Note:Use the excel VBA
sitting and waitting for master!
BR
Howy