|
| 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
|
|
|
|
|
|
|
|
|
|