Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
With statement parameters
I am getting an error message of, "wrong number of arguments or invalid
property assignment" and .Borders is highlighted. see between *@. I was hoping to avoid having a separate with statement for every xlEdgeLeft, xlEdgeTop etc. Can someone let me know if it can be done this way and what I need to do to make it work? thanx With Range("A1:AQ1") .NumberFormat = "General" .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom With *@.Borders*@(xlEdgeLeft, xlEdgeTop, xlEdgeBottom, xlEdgeRight, xlInsideVertical) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With .Font .Name = "Arial" .Size = 8 .Bold = False .ColorIndex = xlAutomatic End With With .Interior .ColorIndex = 15 .Pattern = xlSolid End With End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
SQL & Like Parameters | Excel Discussion (Misc queries) | |||
IF Statement with 3 parameters | Excel Worksheet Functions | |||
too few parameters | Excel Discussion (Misc queries) | |||
IF Statement W/3 Parameters ? | Excel Worksheet Functions |