Hi Andrew,

I agree that the ".FormatHidden" only needs to reference column D. After having some troubles with the "hiding/unhiding" of the row behaving erratically, I just left the redundant references to the other columns from when I was troubleshooting.

"Then, just present the other colums with their correct sign (debit or credit) as appropriate." Sorry, but this is the part that I can't seem to get right.

I have tried by:
> using ADDEBIT/ADCRONLY accross all Asset/Liability columns
PROBLEM: Bank row may need to display in both Sections

> using the ADDEBIT/ADCRONLY in the Current Period column only with the standard ADGET and -ADGET in the other columns depending on the Asset/Liability section
PROBLEM: Balances arrive in both sections so even if one hides the row the totals are wrong.

From the guru comments thus far, I know that I'm most likely missing something quite straightforward, so ...

Andrew I'm going to zip the GL data and email it to you for a look. It's a good dataset for testing because as you flick through the periods many of the "mixed" scenarios come into play.

Thanks, Peter