I have a ListBox that is tied to an excel range using RowSource. I saw a
post here that had a subroutine that Aligned a ListBox column. The problem
is that it used the .List(row,col) property to change the listbox cell with
the aligned data. I'm getting an "Access Denied" error on trying to set the
..List property. I'm pretty sure this is because it is linked to the Excel
rows.

Is there an alternate method to right-aligning data in a ListBox column
linked to an Excel Range. The data in the Excel range is numeric and
formatted using Excel formatting.

inTHANKSadvance