Cell Alignments using a reference worksheet

  • Thread starter Thread starter Viggy
  • Start date Start date
V

Viggy

I have a worksheet the contains the formatting data for a secon
worksheet (without getting into why, this makes the most sense, i
keeps my code very robust)...
The reference worksheet contains different columns, one column ha
color indexes for the second worksheet, the other has column width
ANOTHER HAS CELL ALIGNMENT...

when formatting my main worksheet, the code looks like:

With Range(Rangename)
.Interior.ColorIndex = ... (this line works)
.ColumnWidth = ...
.HorizontalAlignment = ..(HERE'S MY PROBLEM)
End With

The reference worksheet contains cells with either 'xlRight'
'xlCenter' or 'xlLeft'. But when the code above reads the referenc
worksheet, it looks at the values as strings instead of variable names
and doesn't understand... Does anyone know what I can do to my code s
that it understands how to read the values i the reference a
'xlRight', 'xlCenter' or 'xlLeft' insead of strings? I figure I coul
put in the actual integer values, but that'd make the worksheet ver
hard for others to read, which i'm trying to avoid.

Thanks,
Vigg
 
Think you will need to put in the integers unless you want to use some type
of translation/lookup table where you read the constant and translate it
into the appropriate integer for feeding to the alignment command.
 
Back
Top