Clear Macro not working

[Smurfit-Stone]

Can anyone tell me why this macro won't work. I get a message that reads "Expected list separator or )". What should I do? I'm running out of time. Thanks so much.

Sub Clear()
Range("Unit119,Unit122,Unit123,Unit128,Unit134, _
Unit135,Unit136,Unit142,Unit104,Unit120,UnitSlitter, _
UnitWet,UnitDry,Unit125").ClearContents
End Sub

 

[JamesW]

Hi there,

You are misusing your _ seperators.

Try:

Sub Clear()
    Range("Unit119,Unit122,Unit123,Unit128,Unit134," & _
    "Unit135,Unit136,Unit142,Unit104,Unit120,UnitSlitter," & _
    "UnitWet,UnitDry,Unit125").ClearContents
End Sub

 

[VoG]

Try

Sub Clear()
Union(Range("Unit119"), Range("Unit122"), Range("Unit123"), Range("Unit128"), Range("Unit134"), _
Range("Unit135"), Range("Unit136"), Range("Unit142"), Range("Unit104"), Range("Unit120"), Range("UnitSlitter"), _
Range("UnitWet"), Range("UnitDry"), Range("Unit125")).ClearContents
End Sub

 

[Smurfit-Stone]

Peter, once again you've practically saved my life. Thanks so much...this works perfectly. Your a genius.

 

[Norie]

Please don't duplicate threads.