VSTO Cell Alignment Enumeration

[Bob Sullentrup]

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?

--
Bob Sullentrup

[Vacation's Over]

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

"Bob Sullentrup" wrote:

> 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?
>
> --
> Bob Sullentrup

[Bob Sullentrup]

Dear Vacation's Over:

Not VBA, VSTO, Visual Studio Tools for Office.

What's the C# representation?

--
Bob Sullentrup


"Vacation's Over" wrote:

> 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
>
> "Bob Sullentrup" wrote:
>
> > 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?
> >
> > --
> > Bob Sullentrup

[Vacation's Over]

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

"Bob Sullentrup" wrote:

> Dear Vacation's Over:
>
> Not VBA, VSTO, Visual Studio Tools for Office.
>
> What's the C# representation?
>
> --
> Bob Sullentrup
>
>
> "Vacation's Over" wrote:
>
> > 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
> >
> > "Bob Sullentrup" wrote:
> >
> > > 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?
> > >
> > > --
> > > Bob Sullentrup

[Bob Sullentrup]

Folks,

Try this:

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



--
Bob Sullentrup


"Bob Sullentrup" wrote:

> 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?
>
> --
> Bob Sullentrup

[Bob Sullentrup]

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


"Vacation's Over" wrote:

> 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
>
> "Bob Sullentrup" wrote:
>
> > Dear Vacation's Over:
> >
> > Not VBA, VSTO, Visual Studio Tools for Office.
> >
> > What's the C# representation?
> >
> > --
> > Bob Sullentrup
> >
> >
> > "Vacation's Over" wrote:
> >
> > > 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
> > >
> > > "Bob Sullentrup" wrote:
> > >
> > > > 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?
> > > >
> > > > --
> > > > Bob Sullentrup