+ Reply to Thread
Results 1 to 2 of 2

First Empty Row

  1. #1
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    433

    First Empty Row

    I have a file called MyExcel.xlsx, which resides in C:\MyProject\List
    I want to get the first empty row in MyExcel.xlsx, if possible, without opening the Excel File.
    How is this getting done?
    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: First Empty Row

    Hello,

    You can open the file in the background without notification or alerts even if its already open and close it in the background once empty row found. It will appear as if it was never opened. The code below will return the first empty row via message box. You can quote out the message box and use r.Row as the row number if needed.

    Please Login or Register  to view this content.
    Last edited by playaller; 05-24-2014 at 11:29 PM.


    Shelton A.
    If Helpful, Add Reputaion!

+ 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. Replies: 1
    Last Post: 05-26-2014, 01:31 PM
  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. Delete Empty Rows and empty columns from the word table
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 10:51 AM
  5. Replies: 0
    Last Post: 06-22-2012, 11:28 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