Stop searching. Start learning and developing your excel skills.
Macro
VBA
Formula
Function
Shortcut
Tricks

» » Select Columns Contain Error

Select Columns Contain Error

February 06, 2024 |

''' If Error GoTo NextCode

On Error GoTo NextCode

''' Select column A until the last column

Columns("A:A").Select

Range(Selection, Selection.End(xlToRight)).Select

''' Select cells with error

Selection.SpecialCells(xlCellTypeConstants, 16).Select

''' Select columns for cells with error and delete the columns

Selection.EntireColumn.Delete

NextCode:

NextCode Here.. 

No comments:

Post a Comment