Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Helo there - Help with showing deviation (+/-) from a set number... | Excel Worksheet Functions | |||
Justify? | Excel Discussion (Misc queries) | |||
Helo please i can't open the file | Excel Discussion (Misc queries) | |||
e-mail with cdo -- Helo command rejected | Excel Programming | |||
Helo with excel marco | Excel Programming |