topic RE: VB code for Excel cell text to Horizontal Center Alignment in Digital Exchange

VB code for Excel cell text to Horizontal Center Alignment

Mounika__Pasupuleti — Tue, 03 Jan 2023 12:21:00 GMT

Hi,

I need VB code for Excel cell text to Horizontal Center Alignment.

Below is the code i am currently using which is not a complete one as some content and dependencies seems to be missing.

Dim wb, excel, Range As Object

Try

wb = GetWorkbook(Handle, Nothing).ActiveSheet

excel = wb.Application

Range = excel.Selection

Range.HorizontalAlignment = xlCenter

Finally

wb = Nothing

excel = Nothing

Range = Nothing

End Try

Kindly need your help in this.

------------------------------
Pasupuleti Mounika
Senior RPA Developer
Genpact India LLP
Asia/Kolkata
------------------------------

RE: VB code for Excel cell text to Horizontal Center Alignment

michaeloneil — Tue, 03 Jan 2023 21:11:00 GMT

Hi

I think you are almost there with your code but since this is vb you will likely need to change the xlcenter to enumeration instead. The below link will give you a list of alignments which should hopefully help you out with this.

https://learn.microsoft.com/en-us/office/vba/api/excel.xlhalign

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: VB code for Excel cell text to Horizontal Center Alignment

Mounika__Pasupuleti — Wed, 04 Jan 2023 13:53:00 GMT

Thank you Michael for quick response. It worked.

------------------------------
Pasupuleti Mounika
Senior RPA Developer
Genpact India LLP
Asia/Kolkata
------------------------------