By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Error handling Logic - column doesn't exist

You may be receiving data from an external source and are searching for a column by name. It's useful to be able to detect if the column no longer exists or has moved.

The typical code to use is:


lCol = FinddataCol("heading lookup",lRow)
if lCol = 0 then Stop