Error 91 on ListObject

[JuanPa]

Hi. I've got a workbook, with a sheet 'tblPrices', which has a listobject named 'Prices'.
I'm having problems with a code that I'be simplified as follows:

[FONT=Courier New]...
[COLOR=DarkSlateBlue][COLOR=Navy]With[/COLOR] [/COLOR]ThisWorkbook.Worksheets("tblPrices")
    .Activate
    [COLOR=DarkSlateBlue][COLOR=Navy]With[/COLOR] [/COLOR].ListObjects("Prices")
        .Range.Select
        [COLOR=Navy]Debug[/COLOR].[COLOR=Navy]Print [/COLOR].DataBodyRange.Address
    [COLOR=Navy]End With[/COLOR]
[COLOR=Navy]End With[/COLOR]
...[/FONT]

When trying to access the DataBodyRange property, a error message is shown:

Error 91 Object Variable or With block variable not set

I've intentionally activated the worksheet and selected the listobject just to dismiss any focus issue. I have no idea what's going on here.

Thanks a lot,

JuanPa

 

[Andrew Poulsom]

Your code worked for me. Are you sure that you have a dot before DataBodyRange?

 

[JuanPa]

Yes, the point is required since DataBodyRange belongs to .ListObjects("Prices").
It looks really weird because I'd swear I already ran this code and worked. I've already killed Excel and same result.

 

[JuanPa]

Just ran the code on other workbook and worked fine. Something's wrong with my file that is affecting the DataBodyRange behavior.