EXCEL VBA HELP:
Using VBA, in column D of the worksheet, enter Invalid Part Number for a row that does not have a valid part number (one that begins with a letter). Change the Fill color to yellow.
Product code | First digit of product code | Numeric digits of product code | C3972 | C | 3972 | C4758 | C | 4758 | 16332 | 1 | 6332 | P3064 | P | 3064 | 7257 | | 7257 | O4217 | O | 4217 | 38639 | 3 | 8639 | A8218 | A | 8218 | I3870 | I | 3870 | G3677 | G | 3677 | 11947 | 1 | 1947 | E4374 | E | 4374 | N2872 | N | 2872 | D5527 | D | 5527 | G4254 | G | 4254 | E7138 | E | 7138 | E8484 | E | 8484 | P4987 | P | 4987 | 46561 | 4 | 6561 | I3293 | I | 3293 | K7486 | K | 7486 | H4300 | H | 4300 | C2112 | C | 2112 | M8300 | M | 8300 | B6342 | B | 6342 | W6149 | W | 6149 | A4419 | A | 4419 | M4455 | M | 4455 | G2954 | G | 2954 | L5609 | L | 5609 | W6726 | W | 6726 | 9610 | 9 | 610 | S1956 | S | 1956 | I5069 | I | 5069 | 19033 | 1 | 9033 | B5765 | B | 5765 | D7568 | D | 7568 | A6918 | A | 6918 | P2341 | P | 2341 | G1920 | G | 1920 | O6570 | O | 6570 | M6378 | M | 6378 | N4648 | N | 4648 | F4684 | F | 4684 | W5573 | W | 5573 | E5838 | E | 5838 | M6955 | M | 6955 | K9838 | K | 9838 | K2185 | K | 2185 | F2761 | F | 2761 | W4335 | W | 4335 | D1067 | D | 1067 | F5260 | F | 5260 | 42220 | 4 | 2220 | S6642 | S | 6642 | D6221 | D | 6221 | R1872 | R | 1872 | O1680 | O | 1680 | R8949 | R | 8949 | H2376 | H | 2376 | C9873 | C | 9873 | G3529 | G | 3529 | O2257 | O | 2257 | M7530 | M | 7530 | N8876 | N | 8876 | T2989 | T | 2989 | M6953 | M | 6953 | R1295 | R | 1295 | T5488 | T | 5488 | R2449 | R | 2449 | K9260 | K | 9260 | R6450 | R | 6450 | E4491 | E | 4491 | H4298 | H | 4298 | J2568 | J | 2568 | 92605 | 9 | 2605 | P1103 | P | 1103 | W3758 | W | 3758 | H4728 | H | 4728 | F7612 | F | 7612 | A8958 | A | 8958 | L3071 | L | 3071 | F7035 | F | 7035 | E3767 | E | 3767 | L7960 | L | 7960 | D4921 | D | 4921 | D9342 | D | 9342 | J8921 | J | 8921 | S4573 | S | 4573 | A4380 | A | 4380 | C2650 | C | 2650 | N2687 | N | 2687 | I3575 | I | 3575 | 16230 | 1 | 6230 | A4957 | A | 4957 | T7841 | T | 7841 | N9186 | N | 9186 | E5690 | E | 5690 | T7264 | T | 7264 | S3996 | S | 3996 | E8189 | E | 8189 | R5149 | R | 5149 | R9571 | R | 9571 | C9150 | C | 9150 | K7191 | K | 7191 | N6999 | N | 6999 | P6951 | P | 6951 | P9377 | P | 9377 | K7876 | K | 7876 | O1532 | O | 1532 | 52649 | 5 | 2649 | A5533 | A | 5533 | P6878 | P | 6878 | G9991 | G | 9991 | A4956 | A | 4956 | W1688 | W | 1688 | G3491 | G | 3491 | 72841 | 7 | 2841 | N7263 | N | 7263 | E4452 | E | 4452 | M2493 | M | 2493 | K2301 | K | 2301 | M9570 | M | 9570 | J9606 | J | 9606 | D1495 | D | 1495 | I1761 | I | 1761 | K2878 | K | 2878 | I5761 | I | 5761 | Z3972 | Z | 3972 | Z4758 | Z | 4758 | 16332 | 1 | 6332 | P3064 | P | 3064 | 07257 | 0 | 7257 | O4218 | O | 4218 | 38639 | 3 | 8639 | A8218 | A | 8218 | I3873 | I | 3873 | G3677 | G | 3677 | H1947 | H | 1947 | E4374 | E | 4374 | N2872 | N | 2872 | D5527 | D | 5527 | G4254 | G | 4254 | 17138 | 1 | 7138 | E8484 | E | 8484 | P4987 | P | 4987 | E6561 | E | 6561 | I3293 | I | 3293 | 37486 | 3 | 7486 | H4303 | H | 4303 | Z2112 | Z | 2112 | M8303 | M | 8303 | B6342 | B | 6342 | W6149 | W | 6149 | A4419 | A | 4419 | N4455 | N | 4455 | G2954 | G | 2954 | L5609 | L | 5609 | W6726 | W | 6726 | R9613 | R | 9613 | 41956 | 4 | 1956 | I5069 | I | 5069 | S9033 | S | 9033 | B5765 | B | 5765 | D7568 | D | 7568 | A6918 | A | 6918 | P2341 | P | 2341 | G1923 | G | 1923 | O6573 | O | 6573 | N6378 | N | 6378 | N4648 | N | 4648 | F4684 | F | 4684 | W5573 | W | 5573 | E5838 | E | 5838 | N6955 | N | 6955 | K9838 | K | 9838 | L2185 | L | 2185 | F2761 | F | 2761 | W4335 | W | 4335 | 21067 | 2 | 1067 | F5263 | F | 5263 | C2223 | C | 2223 | S6642 | S | 6642 | D6221 | D | 6221 | R1872 | R | 1872 | O1683 | O | 1683 | R8949 | R | 8949 | H2376 | H | 2376 | C9873 | C | 9873 | G3529 | G | 3529 | O2257 | O | 2257 | M7533 | M | 7533 | N8876 | N | 8876 | T2989 | T | 2989 | M6953 | M | 6953 | R1295 | R | 1295 | T5488 | T | 5488 | R2449 | R | 2449 | L9263 | L | 9263 | Q6453 | Q | 6453 | E4491 | E | 4491 | H4298 | H | 4298 | J2568 | J | 2568 | A2605 | A | 2605 | 11103 | 1 | 1103 | W3758 | W | 3758 | H4728 | H | 4728 | F7612 | F | 7612 | A8958 | A | 8958 | L3071 | L | 3071 | F7035 | F | 7035 | E3767 | E | 3767 | L7963 | L | 7963 | D4921 | D | 4921 | D9342 | D | 9342 | J8921 | J | 8921 | S4573 | S | 4573 | A4383 | A | 4383 | C2653 | C | 2653 | N2687 | N | 2687 | I3575 | I | 3575 | M6233 | M | 6233 | A4957 | A | 4957 | T7841 | T | 7841 | N9186 | N | 9186 | E5693 | E | 5693 | T7264 | T | 7264 | S3996 | S | 3996 | E8189 | E | 8189 | Q5149 | Q | 5149 | Q9571 | Q | 9571 | C9153 | C | 9153 | K7191 | K | 7191 | 96999 | 9 | 6999 | P6951 | P | 6951 | P9377 | P | 9377 | K7876 | K | 7876 | O1532 | O | 1532 | C2649 | C | 2649 | A5533 | A | 5533 | P6878 | P | 6878 | H9991 | H | 9991 | A4956 | A | 4956 | W1688 | W | 1688 | H3491 | H | 3491 | T2841 | T | 2841 | N7263 | N | 7263 | E4452 | E | 4452 | M2493 | M | 2493 | 72301 | 7 | 2301 | M9573 | M | 9573 | J9606 | J | 9606 | D1495 | D | 1495 | I1761 | I | 1761 | K2878 | K | 2878 | I5761 | I | 5761 | | | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |