Macro for hiding rows
Norman,
It is an interesting paradox, but strictly speaking the challenge was to make SpecialCells fail with <=8192 blank cells. I think
there were 16384 blank cells in the range where SpecialCells failed. Anyway, do you know why this happens?
Thanks and regards,
KL
"Norman Jones" wrote in message ...
Hi KL,
A significant typo:
Set rng = Range("A1:A16384")
should read:
Set rng = Range("A1:B16384")
---
Regards,
Norman
|