Hello,
Cells A1 to A5 have :
<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" width=64 height=18>1 xyz</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>2 xyz</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>3 xyz</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>4 abc</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>5 abc</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>6 def</TD></TR></TBODY></TABLE>
I would like to underline rows 3, 5 and 6 (that is before the value in A changes to the next value).
Also if possible, to clear the underlines in prior rows - that is if row 2 has an underline that should be cleared and only row 3 to be undelined.
Can anybody help with a simple macro ? Appreciate your time...
thanks...Dan
Cells A1 to A5 have :
<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 48pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" width=64 height=18>1 xyz</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>2 xyz</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>3 xyz</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>4 abc</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>5 abc</TD></TR><TR style="HEIGHT: 13.2pt" height=18><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" height=18>6 def</TD></TR></TBODY></TABLE>
I would like to underline rows 3, 5 and 6 (that is before the value in A changes to the next value).
Also if possible, to clear the underlines in prior rows - that is if row 2 has an underline that should be cleared and only row 3 to be undelined.
Can anybody help with a simple macro ? Appreciate your time...
thanks...Dan