OK, so I have a spreadsheet with 14 columns of data that need to be
filled in. I need to verify that all the data in the spreadsheet for
each row has been filled in. So I know that I can get the last
physical row filled in with anything:

towhere = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row

So can use that to loop through. What I'm looking to do is say, if
only 13 of the columns have been filled in for a particular row, place
invalid in the 15th column.

There is a catch though, if the 13th column has a particular value in
it, say ".done", then the 14th column is not required. Not sure
exactly how to go about this as I wasn't sure if there was a simple
way for starters to get a fast count of the number of elements filled
in with data in a given row and if 14 we are good, if 13, check the
relation between column 13 and 14. If 12 or less just give the error.
Not sure if this is the correct approach or what. Any assistance
would be appreciated. Also keep in mind I do not care about any data
in other columns outside that area (i.e. 15 or up), so need a count or
however it should be done of fields filled in before that. Thanks.

JR