Worksheet Change Target Ranges

[Redled89]

I have the following worksheet change code. My question to the forum is what is the best practice for identifying target range? The below code runs on a worksheet that has 12K lines and growing. To manage this code most efficiently as it grows and changes, is it best to use named ranges for the target range or simply identifying the ranges (ie rngcheck)? I am open to changing code if necessary. It may be that there is no significant advantage either way. I am still learning VBA and would appreciate any advice. Thanks in advance.

Please Login or Register  to view this content.

[protonLeah]

If you use dynamic named ranges, especially for the last one, then the code would be similar to:

Please Login or Register  to view this content.

and at least that part of the code would not have to be edited as the data grows.

[Redled89]

Thanks for the timely reply. Appreciated.