Hello Ed,

Based on my test, the listTbl.DataBodyRange will return the range of data.
The following are two scenarios,

*Before we execute the line "listTbl.DataSource = twsTable", the
listTbl.DataBodyRange will return Nothing in my side. I think this may be
what you have observed.

*After we execute the line "listTbl.DataSource = twsTable", the
listTbl.DataBodyRange will return an Excel range which represents the data
rect. In my side, the listTbl.DataBodyRange.Address is "$A$3:$B$6".

Is this what you see in your side? Have a nice day!


Best regards,
Ji Zhou , remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#notifications.