Hi Everyone
I am using a Dynamic name range to populate my listbox in.
When I set my formulae to only 2 columns and to a certain range it keeps changing for some reason and my listbox gets populated by blanks.
Name range formulae:
=OFFSET(Sheet1!$R$243,1,0,COUNTA(Sheet1!$R$244:$T$265),2)
But it seems to be highlighting much more all the way down to Row 309:
Is there something I am doing wrong?
Thanks in advance.
Regards
I am using a Dynamic name range to populate my listbox in.
When I set my formulae to only 2 columns and to a certain range it keeps changing for some reason and my listbox gets populated by blanks.
Name range formulae:
=OFFSET(Sheet1!$R$243,1,0,COUNTA(Sheet1!$R$244:$T$265),2)
But it seems to be highlighting much more all the way down to Row 309:
Is there something I am doing wrong?
Thanks in advance.
Regards