Offset TotalsRowRange at start but not end

[BuZZarD73]

I'm using VBA to populate a chart in excel and the a range I need is the header row of a data table.

I don't want the first four columns so I have used the following:

Please Login or Register  to view this content.

The problem is that it also extends the range four cells to the right of the end of the header row. How can I keep the end of the range as the end of the header row?

Thanks in advance...

[MickG]

Perhaps this:-

Please Login or Register  to view this content.

[BuZZarD73]

Cheers for that - it works perfectly.

This really helps me out with the way the source data is structured as I will often need to offset the start of the range but not the end.

Thanks again!

[MickG]

You're welcome