+ Reply to Thread
Results 1 to 2 of 2

Guidance reqd for filtering with nearby macro buttons

  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    79

    Guidance reqd for filtering with nearby macro buttons

    In running a macro to filter items it achieves the required results however buttons located beside in rows 1-4 are squashed flat and then be virtually hidden as just like a border single line when the filter is removed.
    My sheet has 4 rows of general info above a table with headings in row 5. The buttons are in columns away from the table.
    How do I restrict the auto filter to the table component rows 5 - 150?
    or stop the macro buttons remaining squashed when the filter is removed?

  2. #2
    Registered User
    Join Date
    10-31-2012
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: Guidance reqd for filtering with nearby macro buttons

    Writing made me look rather than search for hours
    Please Login or Register  to view this content.

+ 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. Auto Selection of Pivot Filed Macro Reqd
    By santhu.g2007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 07:48 AM
  2. Macro array guidance
    By drobinson782001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2013, 11:34 PM
  3. Filtering Using Toggle Buttons
    By Farmall in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 04:32 PM
  4. Command buttons for filtering
    By marc5354 in forum Excel General
    Replies: 16
    Last Post: 02-17-2010, 05:15 PM
  5. Macro reqd
    By toolpusher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2005, 07:51 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