VBA Excel Word - Runtime error 13 Mismatch

  Mary123 08 Mar 13
Locked

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 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 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)

Advertisement

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

OnePlus 2 UK release date, price, specification rumours: When is the OnePlus 2 coming out? July…

We are being sold the ability to spend money we don't have. And we love it

HTC's head designer on what's exciting in designing for mobile right now

Apple Music preview: Why Spotify should be scared of Apple's impressive new music-streaming service

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message