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
Bookmarks