+ Reply to Thread
Results 1 to 6 of 6

finding and selecting first empty cell in a column and offsetting it

  1. #1
    Forum Contributor
    Join Date
    02-23-2015
    Location
    united kingdom
    MS-Off Ver
    14.0.7143.5000 (32-bit)
    Posts
    124

    finding and selecting first empty cell in a column and offsetting it

    As mentioned in the topic I want a code that does find the cell that is first one in a column containing no value.

    I have :

    Please Login or Register  to view this content.
    But i have an error saying :"Application defined or object defined error"

    After finding this cell I want code to select it.


    Any ideas ?

    Thanks

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    6,775

    Re: finding and selecting first empty cell in a column and offsetting it



    Rows.Count + 7 ‼ But max is Rows.Count …

  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
    37,248

    Re: finding and selecting first empty cell in a column and offsetting it

    Please Login or Register  to view this content.
    You can't have "Rows.Count + 7", nor can you go down from there and, consequently, you can't offset down from it

    And the tab name needs to be in double quotes.


    Regards, TMS

  4. #4
    Forum Contributor
    Join Date
    02-23-2015
    Location
    united kingdom
    MS-Off Ver
    14.0.7143.5000 (32-bit)
    Posts
    124

    Re: finding and selecting first empty cell in a column and offsetting it

    Quote Originally Posted by TMS View Post
    Please Login or Register  to view this content.
    You can't have "Rows.Count + 7", nor can you go down from there and, consequently, you can't offset down from it

    And the tab name needs to be in double quotes.


    Regards, TMS
    Many thanks.
    Can you please suggest how do I offset it then?

  5. #5
    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
    37,248

    Re: finding and selecting first empty cell in a column and offsetting it

    Please Login or Register  to view this content.
    Not sure what it is you are trying to do. Certain lack of context.

  6. #6
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,777

    Re: finding and selecting first empty cell in a column and offsetting it

    But this will work if this is what you're after.
    Change Sheet and Column references as required
    Please Login or Register  to view this content.
    Or as TMS suggested
    Please Login or Register  to view this content.

+ 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. Finding and Selecting the Last Nonzero Cell in a Column
    By anujkapur108 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-09-2014, 02:04 PM
  2. [SOLVED] Finding and selecting first empty row
    By thecaitfish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2014, 06:17 AM
  3. [SOLVED] Selecting each cell in a column that isn't empty
    By LaffyAffy13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 10:44 AM
  4. Selecting a specific empty cell of a column
    By mayorofarta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2013, 11:23 AM
  5. Macro - Auto selecting the last empty cell in column
    By rajeevsaraf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2010, 08:55 PM
  6. Selecting Next Empty Cell in Column
    By zimbo109 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2010, 08:50 PM
  7. selecting 1st empty cell in a column
    By gbWildy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2007, 01:18 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