hmm yeah i suppose it would make it simpler :)

still trying to get it to read the formula tho :/

thought maybe changing this doc1.worksheets('sheet2').Range(cell1);
 to this doc1.worksheets('sheet2').Range(cell1).value;

but it just gives an object error

i don't really know what I'm doing :/