Run-time Error '438': Object doesn't support this property or method

M

mika.

Hello, does anyone see a problem with the following code?
SelectInfo is defined as: Sub SelectInfo(ballotWkst As
Worksheet)...Thanks!!

Sub ImportOnBehalfOf()

Dim wkbknum, thisnum As Integer
Dim wkst As Worksheet
Dim wkbk As Workbook

For wkbknum = 1 To (Workbooks.Count - 1)
For Each wkst In Workbooks(wkbknum).Worksheets
If wkst.Name = "Ballot" Then
SelectInfo (wkst) '<--doesn't like this line
End If
Next

Next

End Sub
 
P

pfsardella

Waht happens if you either remove the parentheses or change it to use
the "Call" keyword. I'm assuming that the SelectInfo is either in the
same workbook or that there is a Refernce to the workbook that
contains it.

SelectInfo wkst

or

Call SelectInfo (wkst)

HTH
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WorkSheet or AutoFilter Problem 4
Why is this code not working ? 3
The Information cannot be pasted Message 3
Run-time Error '1004' 1
Run time Error - Application Defined or Object Defined Error Excel Vba 0
Copy from one worksheet to another 12
runtime error 434, object does not support this method or property 4
error message 438 or type mismatch 5

Top