+ Reply to Thread
Results 1 to 7 of 7

Help with VBA code to select first blank cell in a range

  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    25

    Question Help with VBA code to select first blank cell in a range

    Hi all,

    Please I need help with this VBA Code:

    Let's say I have a table from A1 to A20, and I've typed 1 ==> 5 in cells A1: A5

    I need a code to select cell A6 (first blank cell in the range).

    Thank you all in advance

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Help with VBA code to select first blank cell in a range

    Try this
    Please Login or Register  to view this content.
    Last edited by arlu1201; 05-24-2013 at 11:24 AM.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Help with VBA code to select first blank cell in a range

    Here!


    Please Login or Register  to view this content.
    Cheers!
    Deep Dave

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Help with VBA code to select first blank cell in a range

    How about:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-03-2013
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    25

    Thumbs up Re: Help with VBA code to select first blank cell in a range

    Quote Originally Posted by arlu1201 View Post
    Try this
    Please Login or Register  to view this content.
    My dear friend:

    This code is brilliant!!!

    Thank you so much
    Last edited by Sakalansalex; 05-24-2013 at 04:33 PM.

  6. #6
    Registered User
    Join Date
    04-03-2013
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    25

    Thumbs up Re: Help with VBA code to select first blank cell in a range

    Quote Originally Posted by msexcelathome View Post
    Here!


    Please Login or Register  to view this content.
    Thank you su much my friend, your code was really so helpful too

  7. #7
    Registered User
    Join Date
    04-03-2013
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    25

    Thumbs up Re: Help with VBA code to select first blank cell in a range

    Quote Originally Posted by yudlugar View Post
    How about:
    Please Login or Register  to view this content.
    Wnoderful code my friend, and was so helpful too

    Thanks a lot.

+ 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