using trygetvalue program is very slow

Nov 14, 2014 at 10:21 AM
i have a problem using trygetvalue in a excel file.
using this function in each cell to undertsand if my cell is a data and in this case getting value, my program is very slow
without trygetvalue use time for one second to finish instead using trygetvalue in each cell use time for 30 seconds.
how can i bypass this problem?
thanks in advance