Combining two fields’ fails, sometimes.

cindygo · Dec 8, 2010

<!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} table.MsoTableLightShading {mso-style-name:"Light Shading"; mso-tstyle-rowband-size:1; mso-tstyle-colband-size:1; mso-style-priority:60; mso-style-unhide:no; border-top:solid black 1.0pt; mso-border-top-themecolor:text1; border-left:none; border-bottom:solid black 1.0pt; mso-border-bottom-themecolor:text1; border-right:none; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; color:black; mso-themecolor:text1; mso-themeshade:191;} table.MsoTableLightShadingFirstRow {mso-style-name:"Light Shading"; mso-table-condition:first-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastRow {mso-style-name:"Light Shading"; mso-table-condition:last-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingFirstCol {mso-style-name:"Light Shading"; mso-table-condition:first-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastCol {mso-style-name:"Light Shading"; mso-table-condition:last-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingOddColumn {mso-style-name:"Light Shading"; mso-table-condition

dd-column; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} table.MsoTableLightShadingOddRow {mso-style-name:"Light Shading"; mso-table-condition

dd-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} </style> <![endif]--> Hi – I can’t figure this out. Any insight would be appreciated.

The below macro is used to combining the data from column C (address1) and column D (address2).
Sub MergeAddresses()
Dim LR As Long
LR = Range("D" & Rows.Count).End(xlUp).Row

Columns("E:F").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
With Range("E2:E" & LR)
.FormulaR1C1 = "=RC[-2]& "" ""&RC[-1]"
.Copy
.Offset(0, 1).PasteSpecial xlPasteValues
End With
Columns("C:E").Delete xlShiftToLeft
Range("C1").Select
ActiveCell.FormulaR1C1 = "AddrLines"
End Sub

Address1 always has data whereas column address2 typically doesn’t.
<table class="MsoTableLightShading" style="width: 172.2pt; margin-left: 58.2pt; border-collapse: collapse; border: medium none;" width="230" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="width: 28.2pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="top" width="38"> ID
</td> <td style="width: 81pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="top" width="108" nowrap="nowrap"> Address1
</td> <td style="width: 63pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="top" width="84" nowrap="nowrap"> Address2
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 1
</td> <td style="width: 81pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="108" nowrap="nowrap"> 118 17th
</td> <td style="width: 63pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="84" nowrap="nowrap">
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 2
</td> <td style="width: 81pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="108" nowrap="nowrap"> 68224 NW
</td> <td style="width: 63pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="84" nowrap="nowrap"> #25
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 3
</td> <td style="width: 81pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="108" nowrap="nowrap"> 888 Road E
</td> <td style="width: 63pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="84" nowrap="nowrap">
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 4
</td> <td style="width: 81pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="108" nowrap="nowrap"> 444 Sammy Way
</td> <td style="width: 63pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="84" nowrap="nowrap">
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 5
</td> <td style="width: 81pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="108" nowrap="nowrap"> 8546 NE Way
</td> <td style="width: 63pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="84" nowrap="nowrap">
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 6
</td> <td style="width: 81pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="108" nowrap="nowrap"> 111 That Way
</td> <td style="width: 63pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="84" nowrap="nowrap"> Apt B
</td> </tr> </tbody></table>
When I run the macro it combines the cells. In this example there are six records in report and the last record has data in address2.
<table class="MsoTableLightShading" style="width: 145.2pt; margin-left: 58.2pt; border-collapse: collapse; border: medium none;" width="194" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="width: 28.2pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="top" width="38"> ID
</td> <td style="width: 117pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="top" width="156" nowrap="nowrap"> Address1
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 1
</td> <td style="width: 117pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 118 17th
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 2
</td> <td style="width: 117pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 68224 NW #25
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 3
</td> <td style="width: 117pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 888 Road E
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 4
</td> <td style="width: 117pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 444 Sammy Way
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 5
</td> <td style="width: 117pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 8546 NE Way
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 6
</td> <td style="width: 117pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 111 That Way Apt B
</td> </tr> </tbody></table>
In this example there are 5 records in the report. If the last record in the report doesn’t have data in address2 the code will not combined any records after the last populated row with data in address2. The cells for each address are left completely blank.

It only works perfectly if the last record in the report has data in address2.
<table class="MsoTableLightShading" style="width: 145.2pt; margin-left: 58.2pt; border-collapse: collapse; border: medium none;" width="194" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="width: 28.2pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="top" width="38"> ID
</td> <td style="width: 117pt; border-width: 1pt medium; border-style: solid none; border-color: black -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" valign="top" width="156" nowrap="nowrap"> Address1
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 1
</td> <td style="width: 117pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 118 17th
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 2
</td> <td style="width: 117pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> 68224 NW #25
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 3
</td> <td style="width: 117pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> {Empty}
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 4
</td> <td style="width: 117pt; border: medium none; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> {Empty}
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38"> 5
</td> <td style="width: 117pt; border: medium none; background: none repeat scroll 0% 0% silver; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap"> {Empty}
</td> </tr> <tr style="height: 3.5pt;"> <td style="width: 28.2pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="38">
</td> <td style="width: 117pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; padding: 0in 5.4pt; height: 3.5pt;" valign="top" width="156" nowrap="nowrap">
</td> </tr> </tbody></table>
I can’t figure this out. Help.
<!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} table.MsoTableLightShading {mso-style-name:"Light Shading"; mso-tstyle-rowband-size:1; mso-tstyle-colband-size:1; mso-style-priority:60; mso-style-unhide:no; border-top:solid black 1.0pt; mso-border-top-themecolor:text1; border-left:none; border-bottom:solid black 1.0pt; mso-border-bottom-themecolor:text1; border-right:none; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; color:black; mso-themecolor:text1; mso-themeshade:191;} table.MsoTableLightShadingFirstRow {mso-style-name:"Light Shading"; mso-table-condition:first-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastRow {mso-style-name:"Light Shading"; mso-table-condition:last-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingFirstCol {mso-style-name:"Light Shading"; mso-table-condition:first-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastCol {mso-style-name:"Light Shading"; mso-table-condition:last-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingOddColumn {mso-style-name:"Light Shading"; mso-table-condition

dd-column; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} table.MsoTableLightShadingOddRow {mso-style-name:"Light Shading"; mso-table-condition

dd-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} </style> <![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} table.MsoTableLightShading {mso-style-name:"Light Shading"; mso-tstyle-rowband-size:1; mso-tstyle-colband-size:1; mso-style-priority:60; mso-style-unhide:no; border-top:solid black 1.0pt; mso-border-top-themecolor:text1; border-left:none; border-bottom:solid black 1.0pt; mso-border-bottom-themecolor:text1; border-right:none; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; color:black; mso-themecolor:text1; mso-themeshade:191;} table.MsoTableLightShadingFirstRow {mso-style-name:"Light Shading"; mso-table-condition:first-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastRow {mso-style-name:"Light Shading"; mso-table-condition:last-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingFirstCol {mso-style-name:"Light Shading"; mso-table-condition:first-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastCol {mso-style-name:"Light Shading"; mso-table-condition:last-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingOddColumn {mso-style-name:"Light Shading"; mso-table-condition

dd-column; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} table.MsoTableLightShadingOddRow {mso-style-name:"Light Shading"; mso-table-condition

dd-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} </style> <![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} table.MsoTableLightShading {mso-style-name:"Light Shading"; mso-tstyle-rowband-size:1; mso-tstyle-colband-size:1; mso-style-priority:60; mso-style-unhide:no; border-top:solid black 1.0pt; mso-border-top-themecolor:text1; border-left:none; border-bottom:solid black 1.0pt; mso-border-bottom-themecolor:text1; border-right:none; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; color:black; mso-themecolor:text1; mso-themeshade:191;} table.MsoTableLightShadingFirstRow {mso-style-name:"Light Shading"; mso-table-condition:first-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastRow {mso-style-name:"Light Shading"; mso-table-condition:last-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-border-top:1.0pt solid black; mso-tstyle-border-top-themecolor:text1; mso-tstyle-border-left:cell-none; mso-tstyle-border-bottom:1.0pt solid black; mso-tstyle-border-bottom-themecolor:text1; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none; mso-para-margin-top:0in; mso-para-margin-bottom:0in; mso-para-margin-bottom:.0001pt; line-height:normal; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingFirstCol {mso-style-name:"Light Shading"; mso-table-condition:first-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingLastCol {mso-style-name:"Light Shading"; mso-table-condition:last-column; mso-style-priority:60; mso-style-unhide:no; mso-ansi-font-weight:bold; mso-bidi-font-weight:bold;} table.MsoTableLightShadingOddColumn {mso-style-name:"Light Shading"; mso-table-condition

dd-column; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} table.MsoTableLightShadingOddRow {mso-style-name:"Light Shading"; mso-table-condition

dd-row; mso-style-priority:60; mso-style-unhide:no; mso-tstyle-shading:silver; mso-tstyle-shading-themecolor:text1; mso-tstyle-shading-themetint:63; mso-tstyle-border-left:cell-none; mso-tstyle-border-right:cell-none; mso-tstyle-border-insideh:cell-none; mso-tstyle-border-insidev:cell-none;} </style> <![endif]-->

VoG · Dec 8, 2010

Should it be?

Rich (BB code):

LR = Range("C" & Rows.Count).End(xlUp).Row

cindygo · Dec 8, 2010

I looked at that a million times and didn’t see it….

Thanks VoG!
cindygo

Combining two fields’ fails, sometimes.

cindygo

New Member

Excel Facts

VoG

Legend

cindygo

New Member

Similar threads

Forum statistics

Share this page

Combining two fields’ fails, sometimes.

cindygo

New Member

Excel Facts

VoG

Legend

cindygo

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock