Groups > Novell > OpenOffice for Novell > Label already defined error in Calc - VBA




Label already defined error in Calc - VBA

Label already defined error in Calc - VBA
Mon, 21 Apr 2008 02:56:01 GMT
Hi - I am getting the "label $(Arg1) already defined" error. The
highlighted place in the VBA macro is the last REM.  The next statement
is "15 next i".  The label 15 does not appear anywhere else in the
module.  Any ideas  as to what can be wrong?  I have been using this
macro since 2004 under Excel 97.  Here's the code:

For i = 1 To 20
If Worksheets("observations").Cells(7, i + 2).Value <>
"X" Then
GoTo 15
noiv = noiv + 1
ident(noiv + 1) = i
Varname(noiv + 1) = Worksheets("observations").Cells(9, i +
2).Value
Rem Worksheets("results").Cells(i + 10, 6).Value = Varname(noiv +
1)
Rem  Worksheets("results").Cells(i + 10, 7).Value = ident(noiv +
1)
Rem Worksheets("results").Cells(i + 10, 5).Value = noiv
15              Next i
Thanks,
Elderhiker


-- 
elderhiker
------------------------------------------------------------------------
elderhiker's Profile: http://forums.novell.com/member.php?userid=14953
View this thread: http://forums.novell.com/showthread.php?t=324949
Post Reply
about | contact