General information
Category:
Coding, syntax & commands
Hi
Here is a quick way to figure out the value of any Excel constant:
1.Start Excel
2.Create new macro
3.Edit created macro with VBA Editor
4.type the following code
ActiveSheet.Cells(1, 1).Value = xlEdgeBottom
ActiveSheet.Cells(1, 2).Value = xlMedium
ActiveSheet.Cells(1, 3).Value = xl*
etc.
5.Run the macro.Values of the constantns will be placed into spreadsheet.
HTH,
Pavel.
>Now I want to do some borders formating. Macro language says that I have to apply something like:
>
>with app.activeworkbook.activesheet.range("a1:c50").borders(xlEdgeBottom)
> .linestyle=xlContinuous
> .weight=xlMedium
> .ColorIndex=xlAutomatic
>endwith
>
>
>I need some information about Excel constants definition (xlContinuous,xlMedium,xlAutomatic,....xl*).
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only