I am trying to deal with formulas and constants at the same time in a specific column. I have used Union to include both formulas and constants like that

Code: Select all

```
Dim rng As Range
On Error Resume Next
With ws.Columns("P")
Set rng = Union(.SpecialCells(xlCellTypeConstants), .SpecialCells(xlCellTypeFormulas))
End With
On Error GoTo 0
```

Any idea how to handle such a case?