+ Reply to Thread
Results 1 to 5 of 5

How to code delete all value of "Blank" this code is working but 1 Row at a time.

  1. #1
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    160

    How to code delete all value of "Blank" this code is working but 1 Row at a time.

    Good Day, This code is working for delete (1) at a time. but i need is all value of "Blank" is delete when i click cmdDelete Button.

    blank.jpg
    Please Login or Register  to view this content.
    Thanks,

    Regards

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,401

    Re: How to code delete all value of "Blank" this code is working but 1 Row at a time.

    Perhaps
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    160

    Re: How to code delete all value of "Blank" this code is working but 1 Row at a time.

    jindon san,

    if the if no value "Blank" all the data delete..
    Only row that have value "Blank" will be delete.

    Thanks
    Regards

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,401

    Re: How to code delete all value of "Blank" this code is working but 1 Row at a time.

    I see what you mean.
    Try this,
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-04-2017
    Location
    Phillipines
    MS-Off Ver
    2016
    Posts
    160

    Re: How to code delete all value of "Blank" this code is working but 1 Row at a time.

    jindon san,

    Thank you very much..

    Thanks for the help.


    Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete Range that is "locked" by code allowing selection of 1 cell only.
    By Sircool1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2017, 07:05 PM
  2. [SOLVED] Code Clean-Up: Delete "False" worksheet created when "Cancel" is chosen in Input Box
    By Kenny Blackwell in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-31-2015, 10:00 AM
  3. [SOLVED] Does a vba code "Range("A4")" change if I delete row 2?
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2015, 11:48 AM
  4. [SOLVED] Code that copies row of data to another sheet based on text "Complete"/"Delete"
    By Dremzy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-20-2014, 05:51 PM
  5. Replies: 2
    Last Post: 04-20-2014, 11:18 AM
  6. [SOLVED] trying to understand why a code is not working "error 9 subscript out off range"
    By cdafonseca in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-09-2013, 12:33 PM
  7. VBA code "Application.FileSearch" not working in XL 2007 anymore
    By leecs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2010, 01:22 AM

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