Ensure the cells are actually blank. If you enter =len(cell_reference), it
will let you know if it is indeed empty

http://HelpExcel.com

"arudra1974" wrote:

Even after selecting "skip blanks" in the paste special menu in excel, it is
copying the blank cells