Centering an Excel cell from VB & How to add variable to Formula? 1

[jofarrell]

Is there a way to change the alignment of a cell through VB? I need to center the total lines.

Also I have to sum on a range of cells and I know the x and y corordinates but examples I have seen of adding formulas are more along the lines of .Cells("B17&quot.Formula = "=Sum(d15:d16)"

I need to be able to put the formula in (for example) a cell in (14,7) and sum from x = 8 to x = 23 for y = 11 to 13.

Any comments help or suggestions are greatly welcomed

Joanne

 

[Phathi]

Aligning:

xlDoc.Worksheets.Application.Range("A1&quot.Justify =vbLeftJustify (vbCenter,vbRightJustify)

Summing:

i don't think I understand you quite clearly but you could

in order to calculate Rows H to AA and Columns 11 to 13 and display the result in N17 =

xlDoc.Worksheets.Application.Range("N7&quot.Cells = "=SUM(H11:AA13)"

Hope it helps

Ciao

 

[jofarrell]

Thank you so much it was what I was looking for

Joanne