Consulting

Results 1 to 3 of 3

Thread: How to select all rows down?

  1. #1

    How to select all rows down?

    Sorry this is probably a really simple problem but I just can't wrap my head around it.

    I'm trying to autofilter a large amount of data. I want this to work for all rows from row 2 down to the bottom of my data (this will vary) but I'm not sure what the formula for this is?

    This is what I have so far:

    Sub Macro1CONT()
        Rows("1:1").Select
        Selection.AutoFilter
        ActiveSheet.Range("$A$1:$Q$19025").AutoFilter Field:=17, Criteria1:="<>"
        Rows("2:19025").Select
        Selection.Delete Shift:=xlUp
        ActiveSheet.ShowAllData
        Selection.AutoFilter
    End Sub

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Range("A1").CurrentRegion.Offset(1).AutoFilt..........
    Last edited by SamT; 10-30-2015 at 09:05 AM.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    Thank you!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •