B
Bob Barnes
How can I set HorizontalAlignment = xlRight
of a Column or Range thru automation in Access VBA?
Example...this works..
objXLSheet.Columns("F:F").ColumnWidth = 14
This doesn't...
objXLSheet.Range("F1:F500").HorizontalAlignment = xlRight
I am Formatting "Fixed" in an Access Query, but it always left-aligns
in Excel.
Any tips?
TIA - Bob
of a Column or Range thru automation in Access VBA?
Example...this works..
objXLSheet.Columns("F:F").ColumnWidth = 14
This doesn't...
objXLSheet.Range("F1:F500").HorizontalAlignment = xlRight
I am Formatting "Fixed" in an Access Query, but it always left-aligns
in Excel.
Any tips?
TIA - Bob