Hi,

I am running a code that allows me to collect data from several workbooks in one folder. All of the workbooks have the same format. The only issue is that one option within this work book causes a new row to be inserted and therefore throwing my references out. I cannot change the workbook that I am trying to get the data from.

This variable is define "NO_Lis" and will have a value of {"1";"1"}, that would mean 1 row added. {"1";"1";"1"}, would be two added etc etc.

What I would like to do is set up a else if then function so I can update the values I need to reference. I've tried the count function but it doesn't work.

Any help would be greatly appreciated.

Thanks and regards
Christian