The objective is to enter in a text and using the Len with SUSTITUTE in my conditional formatting rule locate those strings that have the value I entered in B14. The rule I'm
using is shown in C4. I can't find my problem - nothing is located LenSubstitute.xlsm
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…