Replies

Thanks for the Dim bit, Hans.
Will re-paste in the code and try again and let you know.

Thanks for the Dim bit, Hans.
Will re-paste in the code and try again and let you know.

Another option from the ‘keep it simple’ school: in eg A2:A6 format each cell with a colour and/or border and/or type style.
If you want to format say all of row 18 with the ‘highlight system’ in cell A4, choose A4, click the Format Painter paintbrush, then click the row number 18 with the paintbrush.
Done.
Option 2: use Conditional Formatting to respond to the presence or absence of a character like H (for Highlight) in a spare column in the row concerned. Cause the conditional format to apply to all the cells you want in that row.
Sorry to spoil the fun…

Another option from the ‘keep it simple’ school: in eg A2:A6 format each cell with a colour and/or border and/or type style.
If you want to format say all of row 18 with the ‘highlight system’ in cell A4, choose A4, click the Format Painter paintbrush, then click the row number 18 with the paintbrush.
Done.
Option 2: use Conditional Formatting to respond to the presence or absence of a character like H (for Highlight) in a spare column in the row concerned. Cause the conditional format to apply to all the cells you want in that row.
Sorry to spoil the fun…

Yes, Hans is right, as you’ve discovered.
I use works 4.5 for some quite serious stuff, and the irritating habit from earlier versions whereby column widths in Report view aren’t stable hasn’t been fixed. (There’s a thing on the M$ site about a workaround, but that’s not stable either.)
The same fault persists in Works 6 (had to get this as 4.5 doesn’t run at all on win2k)
Has it been fixed in Works 7? Has the Window menu been restored?
The database module of Works is potentially a cracking tool, especially for users who find Access terrifying, and this defect is a huge irritation (to some extent redeemed by the ‘copy report output’ tool.)

Yes, Hans is right, as you’ve discovered.
I use works 4.5 for some quite serious stuff, and the irritating habit from earlier versions whereby column widths in Report view aren’t stable hasn’t been fixed. (There’s a thing on the M$ site about a workaround, but that’s not stable either.)
The same fault persists in Works 6 (had to get this as 4.5 doesn’t run at all on win2k)
Has it been fixed in Works 7? Has the Window menu been restored?
The database module of Works is potentially a cracking tool, especially for users who find Access terrifying, and this defect is a huge irritation (to some extent redeemed by the ‘copy report output’ tool.)

(sorry about the 1-man thread…)
Copying ‘as picture’ the picture in Excel, then deleting the picture, and pasting the picture on the clipboard back into excel magically reduces the file size to 1.83.
Alice in Wonderland, smoke and mirrors, waht?

(sorry about the 1-man thread…)
Copying ‘as picture’ the picture in Excel, then deleting the picture, and pasting the picture on the clipboard back into excel magically reduces the file size to 1.83.
Alice in Wonderland, smoke and mirrors, waht?

…. and what makes it odder, is that copying the picture in excel and pasting it into Word retains the colours.
(And a curiosity on file sizes: when they’re set up to virtually fill an A4 landscape page, the .ppt is 1.6MB, the .xls is 4.32 MB and the ex-excel .doc is also 4.32MB
Has someone got shares in Western Digital ?)

…. and what makes it odder, is that copying the picture in excel and pasting it into Word retains the colours.
(And a curiosity on file sizes: when they’re set up to virtually fill an A4 landscape page, the .ppt is 1.6MB, the .xls is 4.32 MB and the ex-excel .doc is also 4.32MB
Has someone got shares in Western Digital ?)

Many thanks, Macropod, it looks like Canberra is quicker than Birmingham or Pittsburgh to figure that one person’s loan is another person’s investment. (Something to do with a brain-dead Monday morning?)
At least we provoked Steve into revising his algebra.
Reassuringly, on constant inputs, =NPER gives identical results to
=((LN(C11*(1+$G$6/100))-LN(C11-B11*$G$6/100))/LN(1+$G$6/100))-1
and I know which I find easier to type!

Many thanks, Macropod, it looks like Canberra is quicker than Birmingham or Pittsburgh to figure that one person’s loan is another person’s investment. (Something to do with a brain-dead Monday morning?)
At least we provoked Steve into revising his algebra.
Reassuringly, on constant inputs, =NPER gives identical results to
=((LN(C11*(1+$G$6/100))-LN(C11-B11*$G$6/100))/LN(1+$G$6/100))-1
and I know which I find easier to type!

here’s the test piece, somewaht got-at.

here’s the test piece, somewaht got-at.

Thanks, Steve, have just replied to this but got timed out on a flaky Limey connection.
A chemistry lesson and a maths lesson in the same day is going some! What’re you like on 8th-century Serbo-Croat grammar?
I **think** your formula is missing a -1 on the end. Using the Goal seek tool on the case i = 0.01, L = 1000, R = 38 gives the anser nearly 30.7 payments, one fewer than your formula.
Repeating with other start values indicates a consistent discrepancy of one payment too many. If one instance is a fluke, isn’t lots the equivalent of what you intellectuals call ‘induction’ and the rest of us call ‘experience’?
Work piece attachement in separate post (trying to beat the timeout.)
Thanks again!