a site that has an index of all the various xlSomething settings for excel objects.
More specificlly the .Borders object
i need to set some linestyles and other stuff and need to know what all the various '=xlLinestyle' options there are.
for example, i want to set a thick border around the range a1:b4, i tryed .linstyle = xlthick and i got a dashed line....
cheers
In the object browser in the VBIDE, just plug xlLineStyle into the search box and find the results.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
omg im having a bad day
i tried that earlier and couldnt find what i was after then just tried it again and found it
thanks xld
Please use meaningful (searchable) titles for your questions.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
