The width of the buttons is reduced to allow the filter arrows to fit in each cell without
overlapping the button.
The buttons won't automatically resize unless the button is exactly the same size as the cell.
So to get the buttons to resize, simply remove the " - iFilter" portion of the code to get:
"Width:=.Width"
Also, each button must have its "move and size with cells" property checkmarked (set to true).
On my system, that is the default - it doesn't have to be set.
I know of no way to change the size/position of the autofilter arrows.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Lottery Numbers.xls: two national lotteries & twelve state lotteries - in the free folder)
"Mr X Z"
wrote in message
...
Hi Jim
Thank you for replying. Apologies for not making myself clear.
The buttons are great but they are fixed in size - I was hoping to
fill the cell that the heading was in plus if that column was resized
the button too would resize. Here is my pathetic attempt...
-snip-