Dynamic Listbox Rowsource property suggestions please

[F0RE5T]

Excel 2007 vba Userform Listbox

Hi

In my listbox "Rowsource" property I refer to a name "ViewProjDetailsList"

This name uses the dynamic formula '=OFFSET(VarData!$BN$5,1,0,COUNTA(VarData!$BN$6:$CC$10),16)'

this works great and is adjustable (reflects) changes when I create / insert a new record line.

My issue is that now my process changes and I now have to copy the records from another workbook and paste over this list.

This then creates a 'Ref#' error in the formula for the Counta range as the amount of rows will increase / decrease each time.

I am thinking of first "deleting" the old records then "inserting the "new" to see if this will solve my issue but I thought I would ask if anyone else has a solution.

many thanks in advance for your ideas / reading this.

F0re5t

 

[F0RE5T]

Hi

I think I have found my error
In the Counta element of the formula my range was BN6:CC10 BUT should of been BN6:BN100. (The BN100 could actually be a longer range limit)

In my testing I now only display the amount of true records (after increaseing) and not blank lines due to setting a long range.


many thanks for all those who read and hopefully my mistake may help someone else.


Forest