This is what I'm using to define my range:
=OFFSET(GL_Data!$A$1,0,0,COUNTA(GL_Data!$A:$A),COUNTA(GL_Data!$1:$1))
My question is:
Can I leave a couple of blank columns and then use some columns to the right of that?
At some point when I am adding these columns I check the data range and it is jumping over the blank columns to include the others I added.
The above formula defines columns A thru F. I put some formulas starting in I and now I see the range is including over to column K. I'm not sure why it is stopping there because I used thru column L.
Does it have anything to do with row 1? Can I still use some columns if I leave row 1 blank?
Thanks for your help.
=OFFSET(GL_Data!$A$1,0,0,COUNTA(GL_Data!$A:$A),COUNTA(GL_Data!$1:$1))
My question is:
Can I leave a couple of blank columns and then use some columns to the right of that?
At some point when I am adding these columns I check the data range and it is jumping over the blank columns to include the others I added.
The above formula defines columns A thru F. I put some formulas starting in I and now I see the range is including over to column K. I'm not sure why it is stopping there because I used thru column L.
Does it have anything to do with row 1? Can I still use some columns if I leave row 1 blank?
Thanks for your help.