Hello again guys..
Actually this problem has been solve by steve and andrew 2 weeks ago..
But at that time , i do it on a small range and the code taht provided by steve and andrew works..
But when i try expanding the range..it happened again..
I dont know what went wrong..
When i try to sort using column AH..theres a gap between the data..
please help me ad refer to the attachment..thanks