I have a worksheet with a column "Folder" and a column "Name"
I need to return the count where the Length of the folder path (Folder) and length of the File name "Name" exceeds 256
I have tried =CountIf(Len([Folder])+Len([Name]),>256) and several variation around that theme but obviously on the wrong track.
I need this to be a value returned in a VBA procedure:
e.g., Msgbox =CountIf(Len([Folder])+Len([Name]),>256)
Hope someone can help. Thank you!!