Paul

Thanks for your reply. This is really neat. I like it!
Thanks again Jacqui

"paul.robinson@it-tallaght.ie" wrote:

> Hi
> In general you would use a Boolean variable to flag when all the checks
> are done and are OK. Now check the value of that varaiable to see if
> you should run your Hierarchies_Check.
>
> eg. Dim OKFlag as Boolean
>
> OKFlag = True 'everything OK so far
> For Each myCell In myRng.Cells
> .....
> If Application.CountA(myRngToCheck) <> myRngToCheck.Cells.Count Then
> .....
> OKFlag = False
> Exit for
> ......
> end if
> ....
> next Cell
> 'If OKFlag is still true then run your next sub
> If OKFlag then
> Hierarchies_Check
> end if
>
>