Cell Alignment
 

Hi again

I am using some code to automatically generate a validation list from a
named range. What I'd now like to do with the code is somehow tell it
some alignment, and wrapping parameters. Can anyone help me? The first
part of the code below works, the second doesn't.

'set validation for Enterer
With ActiveSheet.Cells(myRow, Enterer).Validation
..Delete
..Add Type:=xlValidateList, Formula1:="=Advisor"
End With

'set alignment and wrapping
With ActiveSheet.Cells(myRow, Enterer).Selection
..HorizontalAlignment = xlCenter
..VerticalAlignment = xlCenter
..WrapText = True
End With

Cheers.


---
Message posted from http://www.ExcelForum.com/

Cell Alignment
 

I could definately be wrong here but I don't think you can
set the data format in a data validation list
-----Original Message-----
Hi again

I am using some code to automatically generate a
validation list from a
named range. What I'd now like to do with the code is
somehow tell it
some alignment, and wrapping parameters. Can anyone help
me? The first
part of the code below works, the second doesn't.

'set validation for Enterer
With ActiveSheet.Cells(myRow, Enterer).Validation
.Delete
.Add Type:=xlValidateList, Formula1:="=Advisor"
End With

'set alignment and wrapping
With ActiveSheet.Cells(myRow, Enterer).Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = True
End With

Cheers.


---
Message posted from http://www.ExcelForum.com/

.