ChrisBurch
IS-IT--Management
Excel 97.
I have a funtion that takes 1 argument (integer), and works fine. I am trying to expand it, and need to pass the sheet name to it. I have added the extra arg to the function okay, but when I add it to the sub to pass I get a compiler error telling me that the compiler was "expecting: = ".
I can pass the sheet name to a test function okay as a single arg, the the second arg bodgies me every time. Can/will someone tell what I am dong wrong?
Private Sub CmdBtnWebData_Click()
Dim Last_Row As Integer
Dim WsName As String
WsName = ActiveSheet.name
Last_Row = FindLastRow()
CopyDataRange (Last_Row, WsName) Error here
Thanks,
End Sub
Chris
It worked yesterday.
It doesn't work today.
That's Windows!
I have a funtion that takes 1 argument (integer), and works fine. I am trying to expand it, and need to pass the sheet name to it. I have added the extra arg to the function okay, but when I add it to the sub to pass I get a compiler error telling me that the compiler was "expecting: = ".
I can pass the sheet name to a test function okay as a single arg, the the second arg bodgies me every time. Can/will someone tell what I am dong wrong?
Private Sub CmdBtnWebData_Click()
Dim Last_Row As Integer
Dim WsName As String
WsName = ActiveSheet.name
Last_Row = FindLastRow()
CopyDataRange (Last_Row, WsName) Error here
Thanks,
End Sub
Chris
It worked yesterday.
It doesn't work today.
That's Windows!