Validate column contents with VBA
Posted on 2013-05-15
I am looking for a way I can validate the columns in my spread sheet. At the moment all of the data in the spread sheet is loaded from externally sourced files and web queries -so I want a way I can validate the columns contain the data I expect i.e. a number, a value within a known set. All the columns in the spread sheet are identifiable by named groups so I would like to use these to identify the columns.
My first thought is just to iterate through all columns in the named group (excluding header) and test each row - unless there is a more elegant solution?