Range based on Table cell location

[LITOA]

I am simply trying to format a range of cells that are outside of the table using an offset from the tables DataBodyRange. I would like to do this in case the table gets moved, the formatting moves with it. The code format that I am using works for a single cell, but not a range of cells. I am missing something simple, but can't figure out what. This block of code works just fine:

Please Login or Register  to view this content.

But, if I change it to a range of cells, instead of a single cell, it throws an Error 1004:

Please Login or Register  to view this content.

What am I missing? I have used that format to set a range to multiple cells before, but VBA isn't liking it today, for some reason. Thanks in advance.

[Sintek]

Difficult to say without a sample file depicting your requirement...

[LITOA]

An example has been attached. In the example, I am trying to change the format of sheet1.range("P10:R11") in VBA.

[Sintek]

Perhaps...

Please Login or Register  to view this content.

[LITOA]

Thank you. Do you know the reason that my multiple cell range was not working. I have set a range using that method before, but perhaps not outside the table. Would that be it?

[Sintek]

AFAIK the range.resize is the only option relating to cells offset from actual table...

[LITOA]

Thanks for the help. I have shunned tables up until now, so they are new to me. Building a new sheet with nothing but tables has been an eye opener. 👍