VSTO Cell Alignment Enumeration

[Guest]

I am right-aligning text in a cell using VSTO with this statement:

((Excel.Range)rngBackGround.Cells[7,4]).HorizontalAlignment = -4152;

In VBA, it's xlRight, not -4152.

I have discovered left justification is 1, centered is -4108;

What do I need to include and reference to be able to say something like:

System.Constants.Alignment.xlRight, rather than -4152?

 

[Guest]

looks like you are making 3 changes
sheet to file
number to text
syntax
= XLRight vs .XLRight

not sure ded but this may help

VBA version from VBE>Help

Worksheets("Sheet1").Range("A1:A5").HorizontalAlignment = xlRight

I'm not aware of a workbook setting so you may need to cycle through sheets

dim wks as worksheet

for each wks in workbook.sheets
wks.cells().HorizontalAlignment = xlRight
next wks

not pretty but might get you there

 

[Guest]

Dear Vacation's Over:

Not VBA, VSTO, Visual Studio Tools for Office.

What's the C# representation?

--
Bob Sullentrup

looks like you are making 3 changes
sheet to file
number to text
syntax
= XLRight vs .XLRight

not sure ded but this may help

VBA version from VBE>Help

Worksheets("Sheet1").Range("A1:A5").HorizontalAlignment = xlRight

I'm not aware of a workbook setting so you may need to cycle through sheets

dim wks as worksheet

for each wks in workbook.sheets
wks.cells().HorizontalAlignment = xlRight
next wks

not pretty but might get you there

I am right-aligning text in a cell using VSTO with this statement:

((Excel.Range)rngBackGround.Cells[7,4]).HorizontalAlignment = -4152;

In VBA, it's xlRight, not -4152.

I have discovered left justification is 1, centered is -4108;

What do I need to include and reference to be able to say something like:

System.Constants.Alignment.xlRight, rather than -4152?

 

[Guest]

This is generally a VBA forum

suggest you take my Excel specifics comments to C# forum

again there may not be a workbook wide setting for alignment
set at cell, range or sheet level per my comments

good luck

Dear Vacation's Over:

Not VBA, VSTO, Visual Studio Tools for Office.

What's the C# representation?

--
Bob Sullentrup

looks like you are making 3 changes
sheet to file
number to text
syntax
= XLRight vs .XLRight

not sure ded but this may help

VBA version from VBE>Help

Worksheets("Sheet1").Range("A1:A5").HorizontalAlignment = xlRight

I'm not aware of a workbook setting so you may need to cycle through sheets

dim wks as worksheet

for each wks in workbook.sheets
wks.cells().HorizontalAlignment = xlRight
next wks

not pretty but might get you there

I am right-aligning text in a cell using VSTO with this statement:

((Excel.Range)rngBackGround.Cells[7,4]).HorizontalAlignment = -4152;

In VBA, it's xlRight, not -4152.

I have discovered left justification is 1, centered is -4108;

What do I need to include and reference to be able to say something like:

System.Constants.Alignment.xlRight, rather than -4152?

 

[Guest]

Folks,

Try this:

Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;

 

[Guest]

Dear VO:

This community is labelled "Excel Programming". Accordingly, it should
properly encompass questions about Excel Programming, VBA or VSTO, since both
are used for Excel programming.

May I invite you embrace the newer technology? You'd like it if you did.

Meanwhile, since more and more people will be upgrading, please don't
discourage queries that emerge from the newer domains of technology.
Understand that the VSTO context exists, and don't presume that Excel
programming questions must emanate from the VBA domain.


--
Bob Sullentrup

This is generally a VBA forum

suggest you take my Excel specifics comments to C# forum

again there may not be a workbook wide setting for alignment
set at cell, range or sheet level per my comments

good luck

Dear Vacation's Over:

Not VBA, VSTO, Visual Studio Tools for Office.

What's the C# representation?

--
Bob Sullentrup

looks like you are making 3 changes
sheet to file
number to text
syntax
= XLRight vs .XLRight

not sure ded but this may help

VBA version from VBE>Help

Worksheets("Sheet1").Range("A1:A5").HorizontalAlignment = xlRight

I'm not aware of a workbook setting so you may need to cycle through sheets

dim wks as worksheet

for each wks in workbook.sheets
wks.cells().HorizontalAlignment = xlRight
next wks

not pretty but might get you there

:

I am right-aligning text in a cell using VSTO with this statement:

((Excel.Range)rngBackGround.Cells[7,4]).HorizontalAlignment = -4152;

In VBA, it's xlRight, not -4152.

I have discovered left justification is 1, centered is -4108;

What do I need to include and reference to be able to say something like:

System.Constants.Alignment.xlRight, rather than -4152?