View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Paste Special Function

It can be used to copy a source range with blanks onto destination range that
contains values. When Skip Blanks is checked, only the values in the source
range are pasted while the source range blanks have no impact on the
destination range.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Juanda Calhoun" wrote:

what is the skip blanks function used for in paste special