close

I imported a dBase file as an excel worksheet. Editing the worksheet seems
to work normally except when I try to add a new row at the bottom of the
existing data. When I sort the worksheet on any column, the new row stays at
the bottom. If I insert the new row among the existing rows, it sorts with
the rest of the data. I am using MS Office Excel 2003/SP2.

How are you sorting?..........If by macro, then perhaps the range is
hardcoded in and excludes those new rows...........

Vaya con Dios,
Chuck, CABGx3
quot;John Bloorquot; wrote:

gt; I imported a dBase file as an excel worksheet. Editing the worksheet seems
gt; to work normally except when I try to add a new row at the bottom of the
gt; existing data. When I sort the worksheet on any column, the new row stays at
gt; the bottom. If I insert the new row among the existing rows, it sorts with
gt; the rest of the data. I am using MS Office Excel 2003/SP2.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()