Range/union

Hi

I tried to write a macros to delete multiple cells in a sheet, and only certain ones were cleared, so I ended up recording one and on some lines BEFORE it states RANGE it has UNION, it all works, but what does this mean and why did my way of doing it not delete certain cells. First example is my way, and second example is the recorder.
I also noticed there is ACTIVATE there also?

Thanks

Sheets("Sun Day (3)").Select
    
    Range("B5,D5:K5,O5:U5,B7,D7:K7,O7:U7,B9,D9:K9,O9:U9,B11,D11:K11,O11:U11,D13:K13,O13:U13,D18:K21,L18:U21,B19,B24,D23:U24,E27:F35,G27:H35,F37,L26:L27,J30:L39,N27:Q29,N32:Q38,S27:U31,S34:U39" _
        ).Select
    Range("S34").Activate
   
    Union (Range("A53:U53,D57:K60,L57:U60,B63,F62:Q63,T62:U63,A66:U66,T49:U50,D70:K73,L70:U73,B76,F75:Q76,T75:U76,B5,D5:K5,O5:U5,B7,D7:K7,O7:U7,B9,D9:K9,O9:U9,B11,D11:K11,O11:U11,D13:K13,O13:U13,D18:K21,L18:U21,B19,B24,D23:U24"))
Selectio.Clearcontents
End Sub

And mine:

Sub satnightcleardown()

' satnightcleardown Macro



Sheets("Sun Day (3)").Select
    
    Range("B5,D5:K5,O5:U5,B7,D7:K7,O7:U7,B9,D9:K9,O9:U9,B11,D11:K11,O11:U11,D13:K13,O13:U13,D18:K21,L18:U21,B19,B24,D23:U24,E27:F35,G27:H35,F37,L26:L27,J30:L39,N27:Q29,N32:Q38,S27:U31,S34:U39,S34").Select
    Range("A53:U53,D57:K60,L57:U60,B63,F62:Q63,T62:U63,A66:U66,T49:U50,D70:K73,L70:U73,B76,F75:Q76,T75:U76,B5,D5:K5,O5:U5,B7,D7:K7,O7:U7,B9,D9:K9,O9:U9,B11,D11:K11,O11:U11,D13:K13,O13:U13,D18:K21,L18:U21,B19,B24,D23:U24").Select
    
        Selection.ClearContents
        
End Sub

In your macro (Sub satnightcleardown()) you clear only the second range. If you want to clear both ranges, either use Selection.ClearContents twice

Range("B5,D5:K5 etc etc).Select
Selection.ClearContents
Range("A52:U52,D57:K60... etc etc).Select
Selection.ClearContents

or even better, don't use select at all:

Range("B5,D5:K5 etc etc).ClearContents
Range("A52:U52,D57:K60... etc etc).ClearContents

But don't the recorded macroselect different cells similar to what I have and use 1 selection clear.
I have another macro that selects 9 different ranges on 4 different pages and uses the section clear once too.

Thanks

I have no idea why the macro you recorded translated into code like that. Let's go through it line by line.

Range("B5,D5:K5,O5:U5,B7,D7:K7,O7:U7,B9,D9:K9,O9:U9,B11,D11:K11,O11:U11,D13:K13,O13:U13,D18:K21,L18:U21,B19,B24,D23:U24,E27:F35,G27:H35,F37,L26:L27,J30:L39,N27:Q29,N32:Q38,S27:U31,S34:U39" _
        ).Select

This line is selecting more ranges with one range command. The underscore (_) means that the line is continuing in the next row. You probably selected this range while pressing Ctrl, right?

Range("S34").Activate

I think this is the last cell that you started selecting (S34), so it is now the active cell.

Union (Range("A53:U53,D57:K60,L57:U60,B63,F62:Q63,T62:U63,A66:U66,T49:U50,D70:K73,L70:U73,B76,F75:Q76,T75:U76,B5,D5:K5,O5:U5,B7,D7:K7,O7:U7,B9,D9:K9,O9:U9,B11,D11:K11,O11:U11,D13:K13,O13:U13,D18:K21,L18:U21,B19,B24,D23:U24"))

You selected another range with your mouse. Please note, that VBA forgets the selection before. Also note that the cells that were in the selection before are included in this selection as well. The Union part in this line is useless, I don't know why the recorder included it.

Selection.ClearContents

Erase the contents of the above selection.

Ok. I'll try out what you said then.
As the recorder does look messy in my opinion, so I need to put a selection clear at the end BEFORE i would basically declare a new range.

Understand now! I can see exactly how the other workbook clears down now! I never had as many "RANGE" written in, just the once with multiple cells, then there is a clear selection before each page selection.

Thanks alot!