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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify Recorded Macro 1
How to get a macro to run on all files in a folder and save each one? 0
auto fit & horizontal alignment not working 1
MERGE CELLS 2
PasteSpecial issue 3
keep getting the error message - Compile error: Else without If 2
piece of code keeps failing.... 2
Condense code 2

Back
Top