How do i start a new line of code if i exceed the max. # of characters?
here is my code: i did to continue the Range to a new line.
Sub ClearForm()
ActiveSheet.Unprotect Password:="pec123"
Range("D1:G5,C7:AC8,D11:D14,D22:D25,D33:D36,D44:D47,D55:D58,D66:D69,D77:D80,D88:D91,D99:D102,D110:D113,D121:D124,D132:D135,D143:D146,D154:D157,D165:D168,H11:Z171,AB17,AB28,AB39,AB50,AB61,AB72,AB83,AB94,AB105,AB116,AB127,AB138,AB149,AB160,AB171").Select
Selection.ClearContents
ActiveSheet.Protect Password:="pec123", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=True
End Sub
Bookmarks