Value of next visible mycell within a rng
"Dave Peterson" wrote in message
...
Ps. Thanks for the correction!
Dave Peterson
Thanks for the routine - It did the job.
However, I was looking for a build-in function in Excel that could simply
tell me what the next cell within the defined range would be (as Excel MUST
know). I realise that your fine routine does this, but it eats up a lot of
CPU time if you use through a 40.000+ rows sheet.
But it did the job, so thanks again. I learned something as well.
Rasmus
|