Hi,

I have created a system where users can book pcs for people but i would like to add to my vba coding so when a booking is made, it is automatically set to Centre Across Selection for the text, i have tried " .HorizontalAlignment = xlCenterAcrossSelection" and it kind of worked in the sence that the text was centered but only accross the the first cell in the selection.

Any reasons or advice?

Many thanks,

Nick.