Cell Alignment

  • Thread starter Thread starter TripleT
  • Start date Start date
T

TripleT

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.
 
I could definately be wrong here but I don't think you can
set the data format in a data validation list
 
Back
Top