I have 10 worksheets from wich i want to add the range A2:W900 (10 times this range, one from each worksheet). Every cell in the ranges has formulas with : 'IF(...=..., "" , ...3...) , so every cell has "" or a number . I want to add this ranges-cells but i get #value! ( adding number+text?).I use copy-paste .Maby a macro with special paste will do my job? I can't figure it out. Help!
Alex
Alex