Compile error: Object required

Hello!

The following code produces a "Compile error:Object required". However, i don't see where an argument might be missing. I tried the same code without the 'Dim' and 'Set' (when are they required anyway? i have no clue...), then i get a "ByRef type mismatch" error.

Can anyone help? I guess from the above questions it became clear that i am a beginner (for VBA, not otherwise). Please explain why the error happens and what's the correct way to fix it. Please do no completely rewrite the code, because in that case i probably will not learn the lesson that is hidden in this error.

The error happens in this line:

Please Login or Register  to view this content.

However, if i remove the 'Set', the error moves a little forward to

Please Login or Register  to view this content.

Remove that 'Set' and the error moves to

Please Login or Register  to view this content.

Remove this 'Set' and the error change to the type mismatch on 'faAxis' in this line:

Please Login or Register  to view this content.

Questions:
-What do these error messages mean?
-Why do these errors appear?
-Why do they appear on itemCount, Export and faAction, but not on faItem or faAxis?
-Is there an easy solution to the problem?

Thank you,

Hinnerk

Code:

Please Login or Register  to view this content.

You have the first problems (use of set) because usually set is used with object, range, worksheet, workbook, etc.

Problem

Please Login or Register  to view this content.

I think you have this problem because the Sub:

Please Login or Register  to view this content.

wants four string variables

while you declared:

Please Login or Register  to view this content.

that it's not the same then write:

Please Login or Register  to view this content.

In your declaration VB assumes 'faItem' and 'faAxis' as variant (because you don't specify the cariable type) and only 'faAction' as String.

Regards,
Antonio

Yes, that seems to be the problem. I removed all 'Set' and was more explicit about the types. It's very confusing that

Please Login or Register  to view this content.

does not declare two integers... since it is not, it should not even be allowed input.

But hey, it's just Microsoft, so who cares?

Thanks,

Hinnerk

If you write:

Please Login or Register  to view this content.

Excel assumes 'A' as Variant and 'B' as Integer.

You can also write so in one row:

Please Login or Register  to view this content.

Regards,
Antonio

Hello,
i saw you post and i am having a simular problem but iam not sure if it is the same fix can you help me out please.
i am using the set for iLastRow(IE: getting the last row count in order to auto fill based off that value)


My code keeps crashing on the Set iLastRow....etc...

Please Login or Register  to view this content.

Please help

thanks for you response JosephP

Abousetta,
Thanks for your response but I am afraid that I do not follow you, are you saying that I should not use the “with.....End With”? You show two references one using it just like i have it written...
i am having to use the with...end with due to I am getting the last row count on one sheet and using that value to auto fill down a column on a additional sheet.

Please elaborate

AWE....
thanks, for the clearfication. tying the revised code out now..