Is there a way for VBA to automatically generate version counts on a variable number of rows?
I have the following?
<TABLE style="WIDTH: 71pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=94 border=0><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY><TR style="HEIGHT: 13.5pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.MIM </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 1" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.MIM </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 2" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.MIM </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 3" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 4" height=18><TD class=xl64 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ccffff" width=94 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 5" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 6" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.C </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 7" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.C </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.C </TD></TR></TBODY></TABLE>
I would like it to be:
<TABLE style="WIDTH: 83pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=111 border=0><COLGROUP><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><TBODY><TR style="HEIGHT: 13.5pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0" height=18><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.MIM.01 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 1" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.MIM.02 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 2" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.MIM.03 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 3" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 4" height=18><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ccffff" width=111 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 5" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 6" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.C.01 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 7" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.C.02 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.C.03 </TD></TR></TBODY></TABLE>
Your help in this would be much appreciated.
I have the following?
<TABLE style="WIDTH: 71pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=94 border=0><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY><TR style="HEIGHT: 13.5pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.MIM </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 1" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.MIM </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 2" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.MIM </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 3" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 4" height=18><TD class=xl64 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ccffff" width=94 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 5" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 6" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.C </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 7" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.C </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes" height=18><TD class=xl63 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 71pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=94 height=18>B.WE.C </TD></TR></TBODY></TABLE>
I would like it to be:
<TABLE style="WIDTH: 83pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=111 border=0><COLGROUP><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059" width=111><TBODY><TR style="HEIGHT: 13.5pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0" height=18><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.MIM.01 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 1" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.MIM.02 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 2" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.MIM.03 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 3" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 4" height=18><TD class=xl66 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ccffff" width=111 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 5" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18> </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 6" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.C.01 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 7" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.C.02 </TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes" height=18><TD class=xl65 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 83pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=111 height=18>B.WE.C.03 </TD></TR></TBODY></TABLE>
Your help in this would be much appreciated.