Copy range and paste as value and clearcontants of blank cells and number

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

Please Login or Register  to view this content.

but i m giving error

Does this help?

Please Login or Register  to view this content.