Can someone advise how to tweak this code, if possible, to detect another error type in my workbook? Here is the code I am using.
Example workbook format:
"MAIN COLUMN HEADER A" would be cell A1, "SUB HEADER 1" would be cell A2, "MAIN COLUMN HEADER B" would be cell B1 and so on in this example:
MAIN COLUMN HEADER A | MAIN COLUMN HEADER B |
SUB HEADER 1
sample data
sample data
SUB HEADER 2
sample data
sample data
sample data <<<< must have an empty cell following this sample data cell followed by the new SUB HEADER
SUB HEADER 3
sample data
sample data
sample data
sample data
sample data
sample data
SUB HEADER 4
sample data
sample data
sample data
The error is no empty cell prior to any all CAPS SUB HEADER. any all CAPS SUB HEADER must be preceded by a blank cell which is used to separate different types of info. All of this data is only in column A. I'd just like to be alerted to the errors existence so I can manually inspect it and correct it. Appreciate any assistance with this. Thanks
Bookmarks