Thread: Excel trouble
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Excel trouble

Hi KeepItCool,

i decided to
just go into 'error' mode when the inversed area count = 1
although THAT may be a valid situation.. :(
so now i got to work on that..arghhh


I agree with the rationale - its the route I've been following. As for the
check what about :

If AreasCount = 1 and If CountBlanks(Area) Then = Bug Area

---
Regards,
Norman

"keepITcool" wrote in message
...

oops:) i might indeed..
but with a decent newsreader he should be alerted.


offTopic to Norman.

still working on the 'final' inverse/notrange/complement..

my solution re 8192 bug
iso actually handling it inside the function i decided to
just go into 'error' mode when the inversed area count = 1
although THAT may be a valid situation.. :(
so now i got to work on that..arghhh

<g

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Norman Jones wrote :

Hi KeepITcool ,

You might like to send to the intended recipient's thread <g


---
Regards,
Norman