+ Reply to Thread
Results 1 to 6 of 6

As long as there is a blank space in A2:E100, it must be complete or it cannot be saved

  1. #1
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    88

    As long as there is a blank space in A2:E100, it must be complete or it cannot be saved

    Like file forum 1, it can be saved. Like file forum 2, it can’t be saved jumped out of the screen and said that it must be filled in before it can be saved.

    Each line must be filled in, and there is no blank in it.

    Any help is greatly appreciated
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    88

    Re: As long as there is a blank space in A2:E100, it must be complete or it cannot be save

    Actually there is only FORUM 1 file, FORUM 2 is just a reference example.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,522

    Re: As long as there is a blank space in A2:E100, it must be complete or it cannot be save

    Perhaps
    To ThisWorkbook code module
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    88

    Re: As long as there is a blank space in A2:E100, it must be complete or it cannot be save

    @JINDON GURU When I typed B6 and I took the SAVE button, there was no response, as if I felt it could be archived. Actually, I couldn't archive it and jumped out screen, and the filling was incomplete.
    Attached Images Attached Images

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,522

    Re: As long as there is a blank space in A2:E100, it must be complete or it cannot be save

    Is this not working?
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-31-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    88

    Re: As long as there is a blank space in A2:E100, it must be complete or it cannot be save

    Oh, thank you very much ! It's okay, I want to add REP. to you, but I can't add the same person, add it another day

+ 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] I need a VBA code to add !$J$12 on each cell name from E6:E100.
    By Mr.Castle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2021, 07:26 PM
  2. [SOLVED] Excel auto-complete of long column
    By MaartenRo in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-29-2020, 10:51 AM
  3. Remove from over 2 blank space to 1 space.
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-12-2018, 08:27 PM
  4. [SOLVED] Macro is taking very long to complete
    By kevivu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2015, 03:53 AM
  5. [SOLVED] My Filters seem to take to long to complete
    By Kimo E in forum Excel General
    Replies: 0
    Last Post: 07-26-2006, 08:10 AM
  6. I want to add cells, eg E1-E100
    By Willee in forum Excel General
    Replies: 2
    Last Post: 07-23-2006, 11:25 AM
  7. [SOLVED] Actual Saved FileName begins with Space
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2006, 12:30 PM

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