How to find the same value from the web in Excel help

[Yoichi]

Hi,

If you want to use ReadRange, the following will help you.

dr = dt.AsEnumerable.Where(Function(r) r.ItemArray.Skip(1).Any(Function(o) o.ToString="d7002")).FirstOrDefault()

note: dr is DataRow type

Regards,