+ Reply to Thread
Results 1 to 2 of 2

Filter Arrows In Left Of Cells?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-19-2007
    Location
    Poole England
    MS-Off Ver
    2010
    Posts
    117

    Filter Arrows In Left Of Cells?

    Hello All.

    I really seem to be stuck here :-(
    For cross posting purposes I have also posted here;
    http://www.mrexcel.com/forum/showthread.php?p=3118493


    I have some VBA code that hides a few filters within a range which is;
    Code:

    Sub HideArrows()
        With Range("L26:AC26")
            If .Worksheet.AutoFilterMode Then .Worksheet.AutoFilterMode = False
            .AutoFilter
            .AutoFilter Field:=.EntireRow.Range("N1").Column - .Column + 1, _
                        VisibleDropdown:=False
            .AutoFilter Field:=.EntireRow.Range("O1").Column - .Column + 1, _
                        VisibleDropdown:=False
            .AutoFilter Field:=.EntireRow.Range("P1").Column - .Column + 1, _
                        VisibleDropdown:=False
            .AutoFilter Field:=.EntireRow.Range("Q1").Column - .Column + 1, _
                        VisibleDropdown:=False
        End With
    End Sub
    My problem is for aesthetic reasons .......
    Is there any way to make these arrows show in the left hand side of the cells?
    Excel always puts them in the right hand side of a cell.

    Would be great if somehow I could make them appear in the left.

    Many thanks.
    I hope there's a solution

    All the best

    TheGhost

  2. #2
    Forum Contributor
    Join Date
    02-19-2007
    Location
    Poole England
    MS-Off Ver
    2010
    Posts
    117

    Re: Filter Arrows In Left Of Cells?

    Just to add & show an example:
    As a note,,
    Here's a screenshot of my problem;
    \1

    I hope you can see my predicament.

    Any ideas anybody??

    Just want to be able to sort a list of words in Column M (From M27), but have the filter arrow show up in Q26.

    help

    Difficult 1.
    heyho.

    Many thanks
    John Caines

+ Reply to Thread

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