2 questions
Hello gurus
1) How to programmatically check if a workbook is protected or not?
2) Does the For ...To .. Next loop have a syntax where I could run 2
different number ranges in the same loop. I will illustrate my question by a
fake "code".
For n = 1 To 10 And For n = 21 To 30
... do this
Next n
I came up with an idea where I would inside the loop, use an IF condition at
the beginning and let the loop ignore part of the numbers, but maybe there
is a direct way also.
-----------------------------------
All the best, and thanks in advance.
Uno Kõrsmaa
|