Quote Originally Posted by xld
She only wants one visible column, so don't set ColumnCount to anything other than 1.
xld

If you set ColumnCount to 1 it not only means that only one column is visible but it means that none of the data in other columns are accessible via VBA.

If you want colums to be visible and hide the other columns, but still make the data in the hidden columns availble to VBA you need to use the ColumnWidths property?