+ Reply to Thread
Results 1 to 9 of 9

How do I find the first empty cell in a range of cells in a column

  1. #1
    Forum Contributor
    Join Date
    08-15-2015
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    223

    How do I find the first empty cell in a range of cells in a column

    I am trying to create a macro for a range of cells in a column which takes me to the first empty cell in that range, however when i am running the macro it goes to the bottom of that column. I have drop down menus in the range of cells for which i am making the macro (may be if this info could help)
    My code is as follows
    [/CODE]
    Sub gemempty(Control As IRibbonControl)
    Range("A14:A78").End(xlDown).Offset(1, 0).Select
    End Sub
    [/CODE]

    I have attached a screenshot of where the cursor goes when i run the above macro.

    Regards

    Nirmall
    Attached Images Attached Images

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How do I find the first empty cell in a range of cells in a column

    Because those cells seems to be blank is not blank at all.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: How do I find the first empty cell in a range of cells in a column

    This would take you to the first blank cell in A14:A78, if there is a blank cell in that range.

    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How do I find the first empty cell in a range of cells in a column

    Try this...


    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-15-2015
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    223

    Re: How do I find the first empty cell in a range of cells in a column

    Hi skywriter, u are a beauty, worked like a charm
    Appreciate

  6. #6
    Forum Contributor
    Join Date
    08-15-2015
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    223

    Re: How do I find the first empty cell in a range of cells in a column

    Thread solved,thanks to skywriter,

    thanks sixthsense too for offering an alternative, though did not try it

  7. #7
    Forum Contributor
    Join Date
    08-15-2015
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    223

    Re: How do I find the first empty cell in a range of cells in a column

    Hi, is it possible to highlight the empty cell in a particular color, so that i know where the cursor is???

  8. #8
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: How do I find the first empty cell in a range of cells in a column

    Try this code. Replace all the code I gave you originally, there was a typo in the original code.

    Where it is says on Err it should have been Error.

    Thank you for the rep. points.

    Please Login or Register  to view this content.
    Last edited by skywriter; 12-12-2015 at 01:12 PM.

  9. #9
    Forum Contributor
    Join Date
    08-15-2015
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    223

    Re: How do I find the first empty cell in a range of cells in a column

    Its fine, i am happy with your original code, i will just change On Err to On Error

+ 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] Find next empty cell (Row)within a specific range in column A
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2014, 05:39 AM
  2. Replies: 5
    Last Post: 05-13-2014, 10:19 AM
  3. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  4. how to copy a range of cells, paste them and then find next empty cell
    By comp23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 03:34 PM
  5. [SOLVED] Macro to find empty cells in a range and repalce with the value of a populated cell
    By Markvx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2012, 06:44 AM
  6. [SOLVED] Find empty cells in a range and insert formula in adjacent cell
    By macronovice1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2012, 03:06 PM
  7. Macro to Find any empty cell within a range and show result in another column
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2008, 11:32 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