My data looks like,
1 - TOOL
2-Feb
3 - 1/16 FLAT CARBIDE ENDMILL2 FLUTE/ LOCATION 4G
4 -
5 - C00179
6 -
7 - 26 10 0 0.0625 0. 0. 180. 26 26 20. 80. 600. 10000 16 2 1 26
8 - 0 50. 50. 25. 25. 0. 0. 0.
9 - 0. 2. 3. 2.5 0.0625 2. 1. 0 100. 6. 0
11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 - TOOL
2-Feb
3 - 3/32 FLATCARBIDE ENDMILL 2 FLUTE /LOCATION 4G
4 -
5 - C00180
6 -
7 - 26 10 0 0.09375 0. 0. 180. 26 26 25. 80. 600. 10000 16 2 1 26
8 - 0 50. 50. 25. 25. 0. 0. 0.
9 - 0. 2. 3. 2.5 0.09375 2. 1. 0 100. 9. 0
11 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
I only want to select the cells that start with 7-,9-.
How would I do this in VBA?
Best regards,
Bookmarks