Hi all I keep getting a Language reference for Visual Basic for Applications (VBA)

[Shades1970]

I am using a worksheet change

at first it was changing the work shhet to uppercase and now I also want it to move a row to an other worksheet if Colum CW (101) = Yes.

If I have the uppercase code first it will not mover the row so i put the move row firs and now I keep getting Language reference for Visual Basic for Applications (VBA) error what am i missing please see code

Please Login or Register  to view this content.

any help would be very much appreciated many thanks all.

[rorya]

I keep getting Language reference for Visual Basic for Applications (VBA) error

What's the exact error message please? That's not an error that's familiar to me.

[Shades1970]

I sorry if I did not provide enough info the erroe is as followes:

Rub-Time error '1004':

Method 'Intersect' of object'_ Global' failed.

(this comes up on the following line)
If Intersect(Target, Range("A:G, R:R, AB:AL, AO:AR, AS:AS, AV:AV, AZ:AZ, BD:BD, BH:BH, BL:BL, BP:BP, BT:BT, BX:BX, CB:CB, CF:CF, CJ:CJ, CN:CN, CR:CR, CT:CT")) Is Nothing Then Exit Sub

I hope this helps solve this error many thanks.

[Andy Pope]

If you delete the Target row then the Target object will become an invalid referenced.

Do whatever you need to do to the target row before deleting it.

[rorya]

Since there's no overlap between the ranges you're monitoring, you could also move the last part into an Else clause of the first If statement.

[Shades1970]

Since there's no overlap between the ranges you're monitoring, you could also move the last part into an Else clause of the first If statement.

How do I do that as I did try Else buy I may have been ding it wrong I am not an expert google has been my friend as well as you guys your help is very much appreciated.

[rorya]

Like this:

Please Login or Register  to view this content.

[Shades1970]

Many thanks for that it all work as it should now