C
Cody
I have the following code in a function but when I call it on the sheet I get
the #VALUE Error. Any direction would be greatly appreciated.
Public Function clrck(X As Double, Y As Double, Z As Double)
Dim i As Long
Dim ws1 As Worksheet
Set ws1 = Sheets("Sheet1")
For i = 1 To 10000
If ws1.Cells(i, 1).Value = "" Then
Exit For
Else
Call PinPlane(X, Y, Z, i)
Call PointLine(X, Y, Z, i)
i = i + 23
End If
Next i
X = FindValue()
clrck = X
End Function
the #VALUE Error. Any direction would be greatly appreciated.
Public Function clrck(X As Double, Y As Double, Z As Double)
Dim i As Long
Dim ws1 As Worksheet
Set ws1 = Sheets("Sheet1")
For i = 1 To 10000
If ws1.Cells(i, 1).Value = "" Then
Exit For
Else
Call PinPlane(X, Y, Z, i)
Call PointLine(X, Y, Z, i)
i = i + 23
End If
Next i
X = FindValue()
clrck = X
End Function