General information
Category:
ActiveX controls in VFP
Title:
Code to format cells in Excel
Hello,
I am attempting to format a cell in Excel using the following macro:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2/5/2009 by Martha Kroll
'
'
Range("A57:B57").Select &&This needs to reference (m.rownbr,1)
With Selection
.HorizontalAlignment = xlCenterAcrossSelection
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
End Sub
Obviously this doesn't work if I just copy & paste it into my code. Any suggestions as to how to make this work are greatly appreciated.
Thanks,
Martha
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