Hi,
I just got started with VBA and I think
Could you help me out with this one?
I have a function which I originally intented to have 1 varible.
Sub firstsub()
For Row = 1 To 100
If Sheets("Sheet1").Cells(Row, 46).Value = 1 Then
Sheets("Sheet1").Cells(Row, 47).Value = "Done"
Call func1(Row, 2)
End If
Next Row
End Sub
This works perfect, but when I change one line adding a string to the function [CODE]Call func1(Row, 2)CODE] I get an error message byref argument type mismatch. In the function I have already declared that I am using 2 Integers. What can I do about this?
Cheers
Pete
Bookmarks