Is a table a range or an object?

[natekris8183]

I posted a previous question regarding writing of a Macro for copying and pasting the last line of data in a table on one sheet to the first empty cell of a table on another sheet, however within a weeks time haven't had much luck with responses. So I purchased the Mr. Excel Library book for VBA and Macros in Excel, and I am getting more familiar with the VBA language. Unfortunately this far I have not encountered any decision regarding tables as of yet. While I understand the Method.Object VBA language patterns, I am not understanding of whether a table is identified as a range or as an object? My gut tells me object. This could potentially set me on the right path to writing a macro in VBA that I myself had designed and understand, which is preferable as I can then communicate that language to the next individual if need be. Thanks.

 

[JoeMo]

I posted a previous question regarding writing of a Macro for copying and pasting the last line of data in a table on one sheet to the first empty cell of a table on another sheet, however within a weeks time haven't had much luck with responses. So I purchased the Mr. Excel Library book for VBA and Macros in Excel, and I am getting more familiar with the VBA language. Unfortunately this far I have not encountered any decision regarding tables as of yet. While I understand the Method.Object VBA language patterns, I am not understanding of whether a table is identified as a range or as an object? My gut tells me object. This could potentially set me on the right path to writing a macro in VBA that I myself had designed and understand, which is preferable as I can then communicate that language to the next individual if need be. Thanks.

I believe a Table or ListObject is a member of the Range Object class.