Dear Some one Far Away,
Hope you are doing well.
The VBA code you provided seems to have a potential error related to the usage of Selection.SpecialCells(xlCellTypeBlanks).Select.
When using the SpecialCells method with xlCellTypeBlanks, there is a possibility of encountering a run-time error...