Compile error: Object required

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

Dim A, B As Integer

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:

Dim A, B As Integer

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

You can also write so in one row:

Dim A as Integer, B As Integer

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...

Sub MCR_Data_shtData_Format()
' MCR_Data_shtData_Format Macro
' Formats the Data sheet
Dim iLastRow As Long

'turns off/on screen actions
Application.ScreenUpdating = Fasle

 With shtComp
Set iLastRow = shtComp.Cells(Rows.Count, "D").End(xlUp).Row
End With

Please help