Converting to late binding (for compatibility)
Late binding only makes sense in automation. If you are trying to access
Excel from within Excel (VBA) then late binding is pointless, you are
already bound to Excel.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
wrote in message
ups.com...
Thanks Bob,
I checked this link out but I'm not sure if I understand how to apply
its methods in Excel. My guess would be something like this:
Sub ApplyCommonFormat(MyRange As String, Optional IgnoreBottomRow As
Boolean)
Dim objSheet as Object
Set objSheet = CreateObject("Excel.Worksheet")
With objSheet.Range(MyRange)
With .Borders(xlEdgeLeft)
.Color = 0
.Weight = xlThin
End With
With .Borders(xlEdgeTop)
.Color = 0
.Weight = xlThin
End With
With .Borders(xlEdgeRight)
.Color = 0
.Weight = xlThin
End With
.HorizontalAlignment = xlCenter
End With
If IgnoreBottomRow = False Then
With ActiveSheet.Range(MyRange).Offset(rowoffset:=1)
With .Borders(xlEdgeTop)
.Color = 0
.Weight = xlThick
End With
End With
End If
End Sub
Would this be right?
Tristan
|