VBA Excel Word - Runtime error 13 Mismatch

  Mary123 17:16 08 Mar 13

Hi, I have a project that runs VBA code to extract numerical data from an Excel 2010 spreadsheet and inserts it into a Word 2010 table. The problem seems to be that one of the cells is read as text (when I hover over the highlighted area in VBA is says = " ") instead of a number by the VBA code. I've made sure that all Excel cells are formatted correctly - number 0.000. I've subsituted the formula for a value and the code works with no problems. The formula in the problem cell is: =SQRT(SUM((0.05^2))+SUM(((2(Main!$C$23/R11)(100))/SQRT(3))^2)+SUM((Q24)/SQRT(3))^2). It returns a result of 0.055184538897533, although I have formatted this to show only 3 decimal places. I'd be grateful for any help on this. Many thanks

  Mary123 17:56 08 Mar 13

Sorry, the formula didn't copy well form Excel. It should be: =SQRT(SUM((0.05^2))+SUM(((2(Main!$C$23/R11)(100))/SQRT(3))^2)+SUM((Q24)/SQRT(3))^2) Thanks

  Mary123 18:05 08 Mar 13

Hi again!! I've just realised that this site doesn't show/copy the multiplication sign (star *). I've subsituted an ? where the sign should go: =SQRT(SUM((0.05^2))+SUM(((2?(Main!$C$23/R11)?(100))/SQRT(3))^2)+SUM((Q24)/SQRT(3))^2)

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017