Merge and center

[gr]

Hi, I'm trying to give format to a Cell in Excel form
access. Can someone help me?

I have a text in cell A1 and trying to Merge and center
from A1 to D1.

I tried this statement but not working

gobjeExcel.Cells(1, "A").Align = xlPhoneticAlignCenter

Many thanks,
gr

 

[Bernie Deitrick]

gr,

With gobjeExcel.Range("A33")
.HorizontalAlignment = xlCenter
.Merge
End With

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

oooops!

That, of course, should be:

Range("A11"), not Range("A33")

Sorry about that,
Bernie
MS Excel MVP

 

[Guest]

thx Bernie great!

-----Originalnachricht-----
oooops!

That, of course, should be:

Range("A11"), not Range("A33")

Sorry about that,
Bernie
MS Excel MVP




.