B
Brad
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.
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.