![]() |
Helo with Justify macro
The following macro will work, except when a sentence is bolded - the bolding
is removed if part of the text changes row. How can I correct this? This needs to work primarily for XL 2003 - but it would be nice if it worked for XL 2007 as well Macro Sub Bradstest() shtTextChg.Range("m16:m19").Value = shtTextChg.Range("b8:b11").Value shtTextChg.Range("m16:v21").Justify End Sub Data This illustration assumes an annual premium amount of $1,000.00 based on an annual payment mode. The values shown in the illustration assume that the modal premiums are paid at the beginning of the payment period. In addition, there is a single premium deposit of $999,999.99 on mm/dd/yyyy. The illustration shows total annual premiums assumed. Values will vary depending on the timing of premium payments. Employer contributions, if any, are not reflected in the illustration. |
All times are GMT +1. The time now is 09:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com