I am using excel in office 2013. The following code fails when there are no constants in the selected range. It works fine if the range does not
evaluate to nothing.
I need the following logic
If rStoreConstants <> nothing then do something
Dim RStoreConstants As Range
Set RStoreConstants = TheWorkSheet.Range(Cells(FirstRow, 1), Cells(Lastrow, LastColumn)).SpecialCells(xlCellTypeConstants)