I made it work except for 2 things.
One:

when I run it these columns are not formatted in accounting format.

for example:
Face Amount Annual Premium Amount

2000000 3500000.32 6000000

I would like the amount to be this way

2,000,000 and 3,500,000.32 and 6,000,000

Two:

The last 3 lines always end with null data. Like this:

Owner:
Beneficiary

Company Policy # etc

No data just headings. How do I get rid of these lines?

Thanks

Dave Peterson wrote:
Glad it does what you want.

thanks Dave. I have to tell you that I posted this question in other forum
and no one gave me the answer. It's really working .
[quoted text clipped - 27 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1