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?