Does PasteSpecial SkipBlanks=True work???
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Does PasteSpecial SkipBlanks=True work???

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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?

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com