With SelectionBut Notes doesn't understand xlCenter and xlBottom, so what codes am I supposed to use?
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
These are numeric constants defined in Excel VB, but not in LotusScript. To discover their values, create an Excel macro that displays them in a MsgBox:
Sub snoopy()For me, this generates the following output:
MsgBox "xlCenter = " & xlCenter & ", xlBottom = " & xlBottom
xlCenter = -4108, xlBottom = -4107Now you can make your LotusScript code contain those same constants by adding the following statements in your Declarations section:
Const xlCenter = -4108 Const xlBottom = -4107(You could just use the numbers in your code instead of constant names, but the constants make your code more readable).
This was first published in May 2003