P
PeCoNe
Hallo,
I wrote following subroutine:
Sub prcEUR()
If IEXtm > EURetm Then
EURtm = EURetm
Else
EURtm = IEXtm
End If
If IsEmpty(EURlpr) Or EURpr < EURlpr Then
EURltm = EURtm
EURlpr = EURpr
End If
If IsEmpty(EURhpr) Or EURpr > EURhpr Then
EURhtm = EURtm
EURhpr = EURpr
End If
End Sub
IEXtm and EURetm and EUR... are named fields in my excel sheet.
VBA doesn't recognize these fields.
how can i solve that.
bye Peter Maljers
I wrote following subroutine:
Sub prcEUR()
If IEXtm > EURetm Then
EURtm = EURetm
Else
EURtm = IEXtm
End If
If IsEmpty(EURlpr) Or EURpr < EURlpr Then
EURltm = EURtm
EURlpr = EURpr
End If
If IsEmpty(EURhpr) Or EURpr > EURhpr Then
EURhtm = EURtm
EURhpr = EURpr
End If
End Sub
IEXtm and EURetm and EUR... are named fields in my excel sheet.
VBA doesn't recognize these fields.
how can i solve that.
bye Peter Maljers