Does PasteSpecial SkipBlanks=True work???

Skebo · Mar 4th, 2002, 06:42 PM

I've tried this a million different ways and it doesn't seem to work.
Copy a range of cells that contains empty cells, right-click paste special, select values and skip blanks. The exact same range is pasted in, blank cells and all!!!
How is this supposed to work? Is this a bug or is this user error?

Skebo · Mar 4th, 2002, 06:58 PM

Figured this one out on my own. SkipBlanks only means that blank cells when pasted will not wipeout exsisting data.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 06:42 PM	#1
Skebo New Member Join Date: Feb 2002 Posts: 20	I've tried this a million different ways and it doesn't seem to work. Copy a range of cells that contains empty cells, right-click paste special, select values and skip blanks. The exact same range is pasted in, blank cells and all!!! How is this supposed to work? Is this a bug or is this user error?

Mar 4th, 2002, 06:58 PM	#2
Skebo New Member Join Date: Feb 2002 Posts: 20	Figured this one out on my own. SkipBlanks only means that blank cells when pasted will not wipeout exsisting data.