I need to process a sheet with about 38000 rows. Many rows have an invalid formula like #NAME
I need to bypass that row and go on to the next one. I have tried code like
if first character = "#" or "=" but it returns a "mismatch" error
How do I check "Does this cell have a formula"?
I need to bypass that row and go on to the next one. I have tried code like
if first character = "#" or "=" but it returns a "mismatch" error
How do I check "Does this cell have a formula"?