Sep 13 2021 10:39 AM
With Folha21.ListObjects(1).DataBodyRange
.Columns.Range("A:I,M,P,S,V,X:AF,AT,AV,AX,AZ,BA,BD:BE,BH,BL:BP,BS,BV,BY").NumberFormat = "@"
End With
Sep 13 2021 11:00 AM
You have to write the single-column ranges in C:C format:
With Folha21.ListObjects(1).DataBodyRange
.Columns.Range("A:I,M:M,P:P,S:S,V:V,X:AF,AT:AT,AV:AV,AX:AX,AZ:AZ,BA:BA,BD:BE,BH:BH,BL:BP,BS:BS,BV:BV,BY:BY").NumberFormat = "@"
End With
Also, I don't think you need .Columns in there.
Sep 13 2021 02:49 PM
Sep 13 2021 03:08 PM
Could you attach a sample workbook without sensitive information?