Good afternoon,
I am trying to run a macro that selects the specified cells and clears the contents. It seems once I exceed a certain number of cells in my selection this error message pops up with the arrow pointing to the last line: )).Select
Sub Test_Clear_Contents()
'
'
'Clear Content from selected ranges
Union(Range( _
"BM28:BN57,BR25:BS25,BQ28:BR57,BV25:BW25,BU28:BV57,BZ25:CA25,BY28:BZ57,CD25:CE25,CC28:CD57,CH25:CI25,CG28:CH57,CL25:CM25,CK28:CL57,CP25:CQ25,CO28:CP57,CT25:CU25,CS28:CT57,CX25:CY25,CW28:CX57,DB25:DC25,DA28:DB57,DF25:DG25,DE28:DF57,DJ25:DK25,DI28:DJ57" _
), Range( _
"DY28:DZ57,ED25:EE25,EC28:ED57,EH25:EI25,EG28:EH57,EL25:EM25,EK28:EL57,EP25:EQ25,EO28:EP57,F25:G25,E28:F57,J25:K25,I28:J57,N25:O25,M28:N57,R25:S25,Q28:R57,V25:W25,U28:V57,Z25:AA25,Y28:Z57,AD25:AE25,AC28:AD57,AH25:AI25,AG29:AH53,AG28:AH57,AL25:AM25,AK28:AL57" _
), Range( _
"AX25:AY25,AW28:AX57,BB25:BC25,BA28:BB57,BF25:BG25,BE28:BF57,BJ25:BK25,BI28:BJ57,BN25:BO25" _
)).Select
Range("EP28").Activate
Selection.ClearContents
End Sub
I am fairly new with VBA and will likely not understand what the issue is without it being explained in layman's terms. Everything I've seen and attempted trying from different resources have not solved the issue. Thank you in advance for your help!
Bookmarks