John Caines
Well-known Member
- Joined
- Aug 28, 2006
- Messages
- 1,155
- Office Version
- 2019
- Platform
- Windows
Hello All.
I have some VBA code that hides a few filters within a range which is;
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
John Caines
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 SubMy 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
John Caines
