Hi thank you all for your response we tried the solution of switching to one long variable instead of trying to parse what is in the sheet, this give us some result, the problem is that it enforce us to check the xls each time, After additional check we found that there is a protection checkbox in xls that was not enables under Options > Trust Center >Macro Settings > "Trust access to the VBA project object model" , then the program is running o.k. So indeed it was in the xls Yaffa
... View more