+ Reply to Thread
Results 1 to 6 of 6

Insert value into first free cell

  1. #1
    Registered User
    Join Date
    04-26-2022
    Location
    Czech Republic
    MS-Off Ver
    2016
    Posts
    10

    Insert value into first free cell

    Solved, thank you
    Attached Files Attached Files
    Last edited by Nosal; 06-15-2022 at 04:55 AM. Reason: solved

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Insert value into first free cell

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Insert value into first free cell

    Maybe (untested)
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    04-26-2022
    Location
    Czech Republic
    MS-Off Ver
    2016
    Posts
    10

    Re: Insert value into first free cell

    Thank you guys, both working. I have an idea now. What about find the last used cell and insert value behind it. For example I have values in columns A,B,C,D, colums E,F,G are blank, H,I,J,K are with values and sign value into L.

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Insert value into first free cell

    For example I have values in columns A,B,C,D, colums E,F,G are blank, H,I,J,K are with values and sign value into L.
    No change required...Supplied code will place new value into L

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Insert value into first free cell

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Replies: 5
    Last Post: 08-13-2014, 10:37 AM
  2. Replies: 1
    Last Post: 03-02-2005, 11:36 AM
  3. Replies: 0
    Last Post: 03-01-2005, 03:06 PM
  4. Replies: 0
    Last Post: 03-01-2005, 03:06 PM
  5. Replies: 0
    Last Post: 03-01-2005, 03:06 PM
  6. Replies: 0
    Last Post: 03-01-2005, 03:06 PM
  7. Replies: 0
    Last Post: 03-01-2005, 03:06 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