+ Reply to Thread
Results 1 to 4 of 4

Macro needs to start at (A1) and not (A2)

  1. #1
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Macro needs to start at (A1) and not (A2)

    How do I get this Macro I am working on to start at (A1) instead of (A2). I don't have a headed.
    Last edited by b_rianv; 09-13-2014 at 06:38 AM.

  2. #2
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Re: Macro needs to start at (A1) and not (A2)

    Never mind fixed my problem

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Macro needs to start at (A1) and not (A2)

    When using Autofilter, the top row is not filtered. It's assumed to be the header row whether you have headers of not. There is no way to change that for the Autofilter function.

    One possibility is to have the code insert a blank row at row 1 and then autofilter. At the end of the macro, delete the inserted row 1.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Re: Macro needs to start at (A1) and not (A2)

    ok thanks for the help

+ 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: 5
    Last Post: 05-04-2013, 01:42 PM
  2. Password Macro + Play Macro on start up
    By rmharrison in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 01:41 AM
  3. Using 1 macro to start another
    By Riley_5000 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2009, 06:59 AM
  4. How do you start a Macro?
    By Michael in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-13-2006, 12:15 PM
  5. [SOLVED] start a macro
    By johnT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2005, 03:06 PM

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