+ Reply to Thread
Results 1 to 3 of 3

Skipping NOT blank cells (follow up, back to testing)

  1. #1
    Forum Contributor
    Join Date
    08-31-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    204

    Skipping NOT blank cells (follow up, back to testing)

    Hi all, I thought I had this one resolved but after some testing I ran into some issues. I been working on this for past few days, it runs the 1st and 2nd run ok but on the 3rd one, it overwrites everything on the 2nd run(not the 1st)

    Any idea what could be causing this? Any help is very much appreciated
    Thanks so much


    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Skipping NOT blank cells (follow up, back to testing)

    Hello donyc,

    This article The .SpecialCells(xlCellTypeBlanks) VBA function does not work as expected in Excel may be helpful.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    08-31-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    204

    Re: Skipping NOT blank cells (follow up, back to testing)

    sorry this is little embarassing but i still dont get it.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1