General information
Category:
Coding, syntax & commands
I am using VFP 5 to control Excel. I have been
attempting to use the Macro recorder to provide
some help, but now I am stuck.
All I want to do is select a portion of a row
(say B3:B10) and add a continious line to the top
edge of this selected area.
The code from Excel returned the following:
Range("B3:B10").Select
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous && value of a 1
.Width = xlThin && value of a 2
.ColorIndex = xlAutomatic && value of -4105
EndWith
What is the value of xlEdgeTop? Not sure this syntax
will port to VFP. anyone know how to draw a solid
line through a selected area in Excel using VFP?
Next
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