alexoigres
Board Regular
- Joined
- Dec 2, 2005
- Messages
- 184
Hello Everybody
I have a problem with my macro. I'm pasting some part of my macro here that i think is the problem.
A friend of my help me with this macro and this funtion INSTR.
50% of the macro is working ok, but the rest of the macro is not working.
Case "KKT02"
bookCode = "RT"
If ((InStr(series, "U") <> 0) And (InStr(series, "C") <> 0) And (InStr(series, "P") <> 0)) Then
'GMDAT series applies for US Chevy RT, Canada Chevy RT, and Canada Pontiac RT
'Insert US Chevy RT row
Call getnorUSChevyRTConversionOptions
Call getRTDivCntrSeriesBody("1", "UCM")
Call insertrowtest(6, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Pontiac RT
div = "2"
cntr = "C"
Call changeCanadaPontiacYear
Call getnorCanadaPontiacRTConversionOptions
ElseIf ((InStr(series, "U") <> 0) And (InStr(series, "C") <> 0)) Then
'GMDAT series applies for US Chevy RT, and Canada Chevy RT
'Insert US Chevy RT row
Call getnorUSChevyRTConversionOptions
Call getRTDivCntrSeriesBody("DEL", "UCM")
Call insertrowtest(3, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Chevy RT
div = "1"
cntr = "UCM"
Call getnorCanadaChevyRTConversionOptions
ElseIf ((InStr(series, "U") <> 0) And (InStr(series, "P") <> 0)) Then
'GMDAT series applies for US Chevy RT, and Canada Pontiac RT
'Insert US Chevy RT row
Call getnorUSChevyRTConversionOptions
Call getRTDivCntrSeriesBody("1", "UM")
Call insertrowtest(6, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Pontiac RT
div = "2"
cntr = "C"
Call changeCanadaPontiacYear
Call getnorCanadaPontiacRTConversionOptions
ElseIf ((InStr(series, "C") <> 0) And (InStr(series, "P") <> 0)) Then
'GMDAT series applies for Canada Chevy RT, and Canada Pontiac RT
'Insert Canada Chevy RT
Call getnorCanadaChevyRTConversionOptions
Call getRTDivCntrSeriesBody("1", "CM")
Call insertrowtest(6, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Pontiac RT
div = "2"
cntr = "C"
Call changeCanadaPontiacYear
Call getnorCanadaPontiacRTConversionOptions
ElseIf (InStr(series, "P") <> 0) Then
'GMDAT series applies for Canada Pontiac RT
Call getnorCanadaPontiacRTConversionOptions
div = "2"
cntr = "C"
ElseIf (InStr(series, "U") <> 0) Then
'GMDAT series applies for US Chevy RT
getnorUSChevyRTConversionOptions
div = "1"
cntr = "UM"
ElseIf (InStr(series, "C") <> 0) Then
'GMDAT series applies for Canada Chevy RT
Call getnorCanadaChevyRTConversionOptions
div = "1"
cntr = "CM"
Else
div = "Check series: " & series
End If
series = "TD"
body = Replace(body, "4N", "69")
body = Replace(body, "5H", "48")
When I insert the row and i call these function for the original they are not working....
getnorCanadaPontiacRTConversionOptions
getnorCanadaChevyRTConversionOptions
but...getnorUSChevyRTConversionOptions
works perfect... and I'm using the same logic for the other 2.
Private Function getnorUSChevyRTConversionOptions()
If ((InStr(series, "ULS") <> 0) And (InStr(series, "ULT") <> 0) And (InStr(series, "US") <> 0)) Then
'Usage for T-Car BASE, LS, and LT models - no rpo modification required
ElseIf ((InStr(series, "ULS") <> 0) And (InStr(series, "ULT") <> 0)) Then
'Usage for T-Car LS and LT models - no rpo modification required
ElseIf ((InStr(series, "US") <> 0) And (InStr(series, "ULT") <> 0)) Then
'Usage for T-Car BASE and LT model - requires positive "JCA" in RPO bucket
gmrpo = "&JCA" & gmrpo
ElseIf ((InStr(series, "ULS") <> 0) And (InStr(series, "US") <> 0)) Then
'Usage for T-Car LS and BASE model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
ElseIf (InStr(series, "ULS") <> 0) Then
'Usage for T-Car LS model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
ElseIf (InStr(series, "ULT") <> 0) Then
'Usage for T-Car LT model - requires positive "&JCA" in RPO bucket
gmrpo = "&JCA" & gmrpo
ElseIf (InStr(series, "US") <> 0) Then
'Usage for T-Car LS model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
End If
End Function
Private Sub getnorCanadaChevyRTConversionOptions()
If ((InStr(series, "CLS") <> 0) And (InStr(series, "CLT") <> 0)) Then
'Usage for T-Car LS and LT models - no rpo modification required
ElseIf (InStr(series, "CLS") <> 0) Then
'Usage for T-Car LS model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
ElseIf (InStr(series, "CLT") <> 0) Then
'Usage for T-Car LT model - requires positive "&JCA" in RPO bucket
gmrpo = "&JCA" & gmrpo
End If
End Sub
Private Sub getnorCanadaPontiacRTConversionOptions()
If ((InStr(series, "PLS") <> 0) And (InStr(series, "PLT") <> 0)) Then
'Usage for T-Car LS, and LT models - no rpo modification required
ElseIf (InStr(series, "PLS") <> 0) Then
'Usage for T-Car LS model - requires negative "JCB" in RPO bucket
Call addBodyRPO("/JCB")
ElseIf (InStr(series, "PLT") <> 0) Then
'Usage for T-Car LT model - requires positive "&JCB" in RPO bucket
gmrpo = "&JCB" & gmrpo
End If
End Sub
This is and example what i get:
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2"> <tr> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th valign="bottom"><font face="Tahoma" size="2"><nobr>MY MACRO</nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th valign="bottom"><font face="Tahoma" size="2"><nobr>I SHOULD GET</nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> </tr> <tr> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96464829</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>ULT,PLS,PLT</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&JCA&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&JCA&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96464829</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>ULT,PLS,PLT</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&JCA&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>BAD (no JCA)</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96832759</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>PLS,PLT</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96537407</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>CLS,PLS</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCA</nobr></font></td> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCA</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96537407</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CLS,PLS</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCA</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCB</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>BAD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96458691</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>US,ULS</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&VED&82I-JCA</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&VED&82I-JCA</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> </table>
I hope somebody can help me... because i don't know what my problem is
Thank you
I have a problem with my macro. I'm pasting some part of my macro here that i think is the problem.
A friend of my help me with this macro and this funtion INSTR.
50% of the macro is working ok, but the rest of the macro is not working.
Case "KKT02"
bookCode = "RT"
If ((InStr(series, "U") <> 0) And (InStr(series, "C") <> 0) And (InStr(series, "P") <> 0)) Then
'GMDAT series applies for US Chevy RT, Canada Chevy RT, and Canada Pontiac RT
'Insert US Chevy RT row
Call getnorUSChevyRTConversionOptions
Call getRTDivCntrSeriesBody("1", "UCM")
Call insertrowtest(6, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Pontiac RT
div = "2"
cntr = "C"
Call changeCanadaPontiacYear
Call getnorCanadaPontiacRTConversionOptions
ElseIf ((InStr(series, "U") <> 0) And (InStr(series, "C") <> 0)) Then
'GMDAT series applies for US Chevy RT, and Canada Chevy RT
'Insert US Chevy RT row
Call getnorUSChevyRTConversionOptions
Call getRTDivCntrSeriesBody("DEL", "UCM")
Call insertrowtest(3, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Chevy RT
div = "1"
cntr = "UCM"
Call getnorCanadaChevyRTConversionOptions
ElseIf ((InStr(series, "U") <> 0) And (InStr(series, "P") <> 0)) Then
'GMDAT series applies for US Chevy RT, and Canada Pontiac RT
'Insert US Chevy RT row
Call getnorUSChevyRTConversionOptions
Call getRTDivCntrSeriesBody("1", "UM")
Call insertrowtest(6, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Pontiac RT
div = "2"
cntr = "C"
Call changeCanadaPontiacYear
Call getnorCanadaPontiacRTConversionOptions
ElseIf ((InStr(series, "C") <> 0) And (InStr(series, "P") <> 0)) Then
'GMDAT series applies for Canada Chevy RT, and Canada Pontiac RT
'Insert Canada Chevy RT
Call getnorCanadaChevyRTConversionOptions
Call getRTDivCntrSeriesBody("1", "CM")
Call insertrowtest(6, count)
Call insertFormattedData
'Increase counter
count = count + 1
'Original row is for Canada Pontiac RT
div = "2"
cntr = "C"
Call changeCanadaPontiacYear
Call getnorCanadaPontiacRTConversionOptions
ElseIf (InStr(series, "P") <> 0) Then
'GMDAT series applies for Canada Pontiac RT
Call getnorCanadaPontiacRTConversionOptions
div = "2"
cntr = "C"
ElseIf (InStr(series, "U") <> 0) Then
'GMDAT series applies for US Chevy RT
getnorUSChevyRTConversionOptions
div = "1"
cntr = "UM"
ElseIf (InStr(series, "C") <> 0) Then
'GMDAT series applies for Canada Chevy RT
Call getnorCanadaChevyRTConversionOptions
div = "1"
cntr = "CM"
Else
div = "Check series: " & series
End If
series = "TD"
body = Replace(body, "4N", "69")
body = Replace(body, "5H", "48")
When I insert the row and i call these function for the original they are not working....
getnorCanadaPontiacRTConversionOptions
getnorCanadaChevyRTConversionOptions
but...getnorUSChevyRTConversionOptions
works perfect... and I'm using the same logic for the other 2.
Private Function getnorUSChevyRTConversionOptions()
If ((InStr(series, "ULS") <> 0) And (InStr(series, "ULT") <> 0) And (InStr(series, "US") <> 0)) Then
'Usage for T-Car BASE, LS, and LT models - no rpo modification required
ElseIf ((InStr(series, "ULS") <> 0) And (InStr(series, "ULT") <> 0)) Then
'Usage for T-Car LS and LT models - no rpo modification required
ElseIf ((InStr(series, "US") <> 0) And (InStr(series, "ULT") <> 0)) Then
'Usage for T-Car BASE and LT model - requires positive "JCA" in RPO bucket
gmrpo = "&JCA" & gmrpo
ElseIf ((InStr(series, "ULS") <> 0) And (InStr(series, "US") <> 0)) Then
'Usage for T-Car LS and BASE model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
ElseIf (InStr(series, "ULS") <> 0) Then
'Usage for T-Car LS model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
ElseIf (InStr(series, "ULT") <> 0) Then
'Usage for T-Car LT model - requires positive "&JCA" in RPO bucket
gmrpo = "&JCA" & gmrpo
ElseIf (InStr(series, "US") <> 0) Then
'Usage for T-Car LS model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
End If
End Function
Private Sub getnorCanadaChevyRTConversionOptions()
If ((InStr(series, "CLS") <> 0) And (InStr(series, "CLT") <> 0)) Then
'Usage for T-Car LS and LT models - no rpo modification required
ElseIf (InStr(series, "CLS") <> 0) Then
'Usage for T-Car LS model - requires negative "JCA" in RPO bucket
Call addBodyRPO("/JCA")
ElseIf (InStr(series, "CLT") <> 0) Then
'Usage for T-Car LT model - requires positive "&JCA" in RPO bucket
gmrpo = "&JCA" & gmrpo
End If
End Sub
Private Sub getnorCanadaPontiacRTConversionOptions()
If ((InStr(series, "PLS") <> 0) And (InStr(series, "PLT") <> 0)) Then
'Usage for T-Car LS, and LT models - no rpo modification required
ElseIf (InStr(series, "PLS") <> 0) Then
'Usage for T-Car LS model - requires negative "JCB" in RPO bucket
Call addBodyRPO("/JCB")
ElseIf (InStr(series, "PLT") <> 0) Then
'Usage for T-Car LT model - requires positive "&JCB" in RPO bucket
gmrpo = "&JCB" & gmrpo
End If
End Sub
This is and example what i get:
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2"> <tr> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th valign="bottom"><font face="Tahoma" size="2"><nobr>MY MACRO</nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> <th valign="bottom"><font face="Tahoma" size="2"><nobr>I SHOULD GET</nobr></font></th> <th align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></th> </tr> <tr> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96464829</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>ULT,PLS,PLT</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&JCA&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&JCA&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96464829</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>ULT,PLS,PLT</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&JCA&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>BAD (no JCA)</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96832759</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>PLS,PLT</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&L91&ML4&B19&GH4&D8R&BMF</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96537407</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>CLS,PLS</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCA</nobr></font></td> <td bgcolor="#FFFF00" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCA</nobr></font></td> <td bgcolor="#FFFF00" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96537407</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CLS,PLS</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCA</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&82I-B19&VED/JCB</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>BAD</nobr></font></td> </tr> <tr> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>96458691</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>US,ULS</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&VED&82I-JCA</nobr></font></td> <td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td> <td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>&VED&82I-JCA</nobr></font></td> <td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>GOOD</nobr></font></td> </tr> </table>
I hope somebody can help me... because i don't know what my problem is
Thank you