hello
i have data in range AP10:AP300 i select this range and copy than paste as value in range BI10,

now i have data only in BI10:BI35 and i m trying to selection blank range with below code
Range("BI10:BI300").SpecialCells(xlCellTypeBlanks).Select
but i m giving error