1004 Error - Application or object defined error

[davidman1]

Hi

When I run my macro I get a Run-time 1004 Error on EE_Id, EE_Id is Long - could somebody please tell me where I'm going wrong with this? (I get the same error if I use EE_Id or EE_Id.Value)

Please Login or Register  to view this content.

[Norie]

If EE_Id is declared as Long the error message would be 'Invalid Qualifier...'.

The error you describe is more likely a problem with Cells(RowNumRTW, 1).

What's the value of RowNumRTW when you get the error?

[davidman1]

0 - I forgot to tell it what FirstRowRTW and LastRowRTW actually are.

Cheers