+ Reply to Thread
Results 1 to 3 of 3

Clear cell value if cell is blank

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    India,Maharashtra
    MS-Off Ver
    Excel 2003
    Posts
    9

    Clear cell value if cell is blank

    Dear all

    please solve my below problem,I have attached a sample file for clearify my issue.

    IF DATA-7 CELL IS BLANK,I WANT TO DELETE DATA FROM DATA-1 TO DATA-6 IN EVERY ROW OF EACH GROUP USING VBA CODE

    Regards
    Ashfaque
    Attached Files Attached Files

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Clear cell value if cell is blank

    Try the following code

    Please Login or Register  to view this content.
    If you like my contribution click the star icon!

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    India,Maharashtra
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Clear cell value if cell is blank

    Thanks..... OllieB

    Its working, thanks a lot for your help to me

    Ashfaque

+ 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