Results 1 to 3 of 3

Find the row number of the first cell entry in a column

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2007
    Posts
    7

    Find the row number of the first cell entry in a column

    When I do a sort with a macro key, I always get a number of blank rows above the first row with any data. I would like to automatically determine how many rows there are until my first row of data and then delete these rows automatically by editing the VBA code of my sort macro Sub.

    I have be trying something like row(3,cell(value,$a$1)) and then deleting these rows where $a$1 is where I am trying to calculate where that first data row is, but it is not working consistantly.

    My sort range will also give me a large number of blank rows after the rows of data are sorted together which is adding to the complexity for me.

    Any ideas would be greatly appreciated.
    Last edited by catmandu57; 03-10-2008 at 11:15 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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