View Full Version : Solved: Linestyle constant values

03-03-2009, 02:04 PM
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.... :shifty:



03-03-2009, 02:06 PM
In the object browser in the VBIDE, just plug xlLineStyle into the search box and find the results.

03-03-2009, 02:10 PM
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


03-03-2009, 03:57 PM
Please use meaningful (searchable) titles for your questions.