ExcelBanter - Paste Special Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Paste Special Function (https://www.excelbanter.com/excel-discussion-misc-queries/83722-paste-special-function.html)

Juanda Calhoun

Paste Special Function

what is the skip blanks function used for in paste special

Ron Coderre

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

All times are GMT +1. The time now is 02:42 AM.