Dynamic Named Range across columns instead of rows

sharky12345 · May 2, 2018

Can someone show me how to adapt this so that the dynamic range stays on row 30 but goes across used columns, not rows?

=OFFSET(Analysis!$B$22,0,0,COUNTA(Analysis!$B$22:$B$28),1)

ttray33y · May 2, 2018

sharky12345 said:
Can someone show me how to adapt this so that the dynamic range stays on row 30 but goes across used columns, not rows?

example below will let you have a dynamic range for entire Row 2 with respect to your starting reference cell B22

Code:

=OFFSET(Analysis!$B$22,0,0,1,COUNTA(Analysis!$2:$2)+1)