OFFSET & PivotTable range. Dynamic row range yes, but dynamic column range?

[excelerino]

Hi all!

So very basic question here, how do I properly refer to a range of columns? I'm using this formula

=OFFSET('MUST WIN Modules'!$A$1;3;0;COUNTA('MUST WIN Modules'!$A:$A)-1;60)

instead of typing the actual number at the end, I'd like to have the column range be dynamic as well. I feel like the answer will be very simple, I just don't see it. Thanks in advance!

 

[excelerino]

Solved.

=OFFSET('MUST WIN Modules'!$A$1;3;0;COUNTA('MUST WIN Modules'!$A:$A)-1;COUNTA('MUST WIN Modules'!$A$4:$XF$4))