+ Reply to Thread
Results 1 to 5 of 5

Find & select 1st blank cell in a range of formulated column cells

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    27

    Find & select 1st blank cell in a range of formulated column cells

    Hello all,
    I tried using the following VBA to have the first blank cell within the E9:E48 range be selected whenever the worksheet is activated.

    Please Login or Register  to view this content.
    The problem? It selects the E49 cell because the E9:E48 column cells have formulas in them. If I have a value in cell E12, for example, what VBA code will be needed to have the E13 cell be selected?

    Thanks for your support or even considering the help on this issue!
    JN

  2. #2
    Forum Contributor
    Join Date
    10-12-2012
    Location
    Bournemouth
    MS-Off Ver
    Excel 2010 / Excel 2007
    Posts
    126

    Re: Find & select 1st blank cell in a range of formulated column cells

    Hi

    You might need to do something like the below:

    Please Login or Register  to view this content.
    I'm not sure - but hopefully should work. I tried to replicate the problem in Excel, but with no luck - when I tried it, it selected the next blank cell. If this doesnt work you could try something like:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-25-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Find & select 1st blank cell in a range of formulated column cells

    I think this should work. I tried it on a sample and it selects the first cell with a blank value even if there is a formula in that cell.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-26-2012
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Find & select 1st blank cell in a range of formulated column cells

    djdjdj
    That works perfectly! I did try using this code on formulated cells and it works just as well. A double treat!
    The code selects the first blank cell so fast that it went unnoticed... even on an old slow machine. I like that it does not have to search in so many places before it lands where it supposed to land.

    Thanks so much

  5. #5
    Forum Contributor
    Join Date
    04-25-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Find & select 1st blank cell in a range of formulated column cells

    No worries!

+ 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. Clear column D cell based on a blank formulated column A cell
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2013, 11:05 AM
  2. Replies: 2
    Last Post: 07-26-2012, 09:57 AM
  3. [SOLVED] Select all cells in a column up to a blank cell
    By nemadrias in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2006, 04:10 PM
  4. [SOLVED] Find first blank cell in single column named range
    By tig in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-09-2006, 01:40 PM
  5. Find Last Cell in Column, Select all cells above it
    By MAYDAY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2005, 07:01 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