If you have an IF then you need an end if IF more than one line

if tt then
ddd
end if

or
if tt then ddd

no end if needed

--
Don Guillett
SalesAid Software

"John" wrote in message
...

I got it to work, however, my version XL97 doesnt seem to like
the End If statement. I'll play with this over the weekend to see if I
can put all of the code together.

Thanks again

John