+ Reply to Thread
Results 1 to 5 of 5

How to reference first blank row in vba?

  1. #1
    Registered User
    Join Date
    11-03-2017
    Location
    St. John's Newfoundland
    MS-Off Ver
    2010
    Posts
    19

    How to reference first blank row in vba?

    Hello everyone, I want to know what code to use to reference the first blank row of a spreadsheet. I know the code for the first blank cell in a column is something like:

    Please Login or Register  to view this content.
    I would like to make LR reference the first blank row in a spreadsheet instead of the first blank cell in a column. What code should I use for this?
    Last edited by amwkl4; 11-20-2017 at 09:25 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: How to reference first blank row in vba?

    This will get you to the last cell in a sheet, from there, you can add 1 to the rws, or col

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: How to reference first blank row in vba?

    Red 1 = Row number

    Please Login or Register  to view this content.
    Kind regards
    Leo

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: How to reference first blank row in vba?

    Many, many, many ...... many solutions ...
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-03-2017
    Location
    St. John's Newfoundland
    MS-Off Ver
    2010
    Posts
    19

    Re: How to reference first blank row in vba?

    Thanks for the help, I used Dave's solution to fix my problem. Code does exactly what I wanted to do.

+ 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] Reference cell formula returning 0 when BLANK, need BLANK to show
    By williamc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2016, 04:23 PM
  2. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  3. If formula to return blank if reference cell blank
    By dhooper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2013, 08:56 PM
  4. Replies: 5
    Last Post: 03-23-2011, 07:09 PM
  5. Replies: 1
    Last Post: 09-23-2010, 01:24 PM
  6. Replies: 4
    Last Post: 07-15-2008, 01:42 PM
  7. how to get excel to display blank if reference cell blank
    By silent1(not) in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2005, 10:55 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