Hello

I'm using Adagio Ledger 8.0D 061013 with the .RowFormat and FormatHidden to try and make the Bank row on a Balance Sheet jump up and down the sheet according to the balance being an Asset or Liability. Instead it's making me jump up and down... I've done this successfully a couple times before but here are my current problems:

1. Since the sheet has multiple columns the possibility exists that the row could have a Debit balance in some columns and a credit balance in others. While I have "successfully" handled this before I wonder if it's just that I've been lucky that the data never encountered a situation where the column data was actually mixed (asset & liability). Can this "mixed" row be handled properly ? Any sample data with specs that can show the correct formulas to handle this ?

2. The spec is hiding some rows and I just can't seem to get them unhidden no matter what I do and I've tried everything. Everything except what works. So go ahead and embarass me by telling me how simple this is. Among other things, I've tried removing the .RowFormat and Recalculating, Selecting across the rows and RightClick|Unhide, Selecting entire sheet and Format|Rows|Unhide - No luck can't get back the rows to troubleshoot them.

Help

Pete