Sub selectionnerBIS()
Const InclureErreur = False 'False alors on inclut les cellules avec valeur d'erreur de la colonne A
'True alors on exclut les cellules avec valeur d'erreur de la colonne A
Dim t, i&, derlig&, PremColVide&
Dim xrg1 As Range, xrg2 As Range, xrg As Range
On Error Resume Next
Application.ScreenUpdating = False
derlig = Cells(Rows.Count, "a").End(xlUp).Row
PremColVide = ActiveSheet.UsedRange.Column + ActiveSheet.UsedRange.Columns.Count
t = Range("a2:a" & derlig)
For i = 1 To UBound(t)
If IsError(t(i, 1)) Then
If Not InclureErreur Then t(i, 1) = Empty
Else
t(i, 1) = IIf(t(i, 1) <> "", CVErr(xlErrNA), "")
End If
Next i
Cells(2, PremColVide).Resize(UBound(t)) = t
Set xrg = Cells(2, PremColVide).Resize(UBound(t)).SpecialCells(xlCellTypeConstants, xlErrors)
If Not xrg Is Nothing Then xrg.Offset(, -PremColVide + 2).Select Else xrg.Offset(, 1).Select
Columns(PremColVide).Delete
End Sub