|re: "some VB Code to check each line in collumn "C" and "D" "|
There are an awful lot of "lines" (rows) in an Excel 2010 spreadsheet. Are you sure you want to check every one of them?
I'm assuming that your data only uses a portion of the spreadsheet. If there is a column that will always have data down to the bottom of your data set, then we can use that column to determine how many rows that we really have to check.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.