[TABLE="width: 1224"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Holdings[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Duration[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Meets Expectation[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD]Meets Expectation[/TD]
[/TR]
[TR]
[TD]Meets Expectation[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD]Meets Expectation[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD]Meets Expectation[/TD]
[/TR]
</tbody>[/TABLE]
"There is N/A under Holdings and I filled N/A in next columns manually, before "Meets Expectation" column, also there are N/A below and I want them filled automatically with some VBA coding till its blank.
Thanks in Advance
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Holdings[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]Duration[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD]Meets Expectation[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD]Meets Expectation[/TD]
[/TR]
[TR]
[TD]Meets Expectation[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD]Meets Expectation[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD]Meets Expectation[/TD]
[/TR]
</tbody>[/TABLE]
"There is N/A under Holdings and I filled N/A in next columns manually, before "Meets Expectation" column, also there are N/A below and I want them filled automatically with some VBA coding till its blank.
Thanks in Advance