I think you misunderstand the purpose of "skip blanks".

Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.

See help on "skip blanks".


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
wrote:

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