Oh, I see. The more details you give, the easier it is for me (and others) to help you. I also wanted to ask you when is this sub run, upon clicking a button, or upon which event?
What if you were to use the following, instead:
Private Sub Detail_Format(Cancel As Integer, FormatCount As...