Even after selecting "skip blanks" in the paste special menu in excel, it is copying the blank cells
A arudra1974 Feb 19, 2005 #1 Even after selecting "skip blanks" in the paste special menu in excel, it is copying the blank cells
G galimi Feb 19, 2005 #2 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
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