Thanks, but that resulted in a #Value error.

Can you elaborate on why it is a bad idea to use such large ranges? I can probably reduce it some but this spreadsheet will be pretty big.