ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   #VALUE Error (https://www.excelbanter.com/excel-discussion-misc-queries/158613-value-error.html)

cody

#VALUE Error
 
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


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com