Hi All,

I may be having a dumb day here, but....

I am getting the following error:

"Cannot set HorizontalAlignment Property of the Range Class" from this
code:

Sub Test()

With Range("G4")

.Formula = "GP%"
.HorizontalAlignment = xlHAlignCenter
.Font.Bold = True

End With

End Sub


It makes no difference whether I use 'xlHAlignCenter' or -4108 (the
intrinsic value).

G4 is not protected.


Any help is much appreciated.

Thanks,

Alan.