View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Rasmus[_3_] Rasmus[_3_] is offline
external usenet poster
 
Posts: 7
Default 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