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
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

VBA Excel Word - Runtime error 13 Mismatch


Mary123

Likes # 0

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

Like this post
Mary123

Likes # 0

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

Like this post
Mary123

Likes # 0

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)

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Windows 10 for phones UK release date, price and new features: When will my phone get Windows 10?

IDG UK Sites

It's World Backup Day 2015! Don't wait another minute: back up now

IDG UK Sites

Get the free Adobe Comp CC iPad app for rapid layout design

IDG UK Sites

New 13-inch Retina MacBook Pro (early 2015, 2.7GHz) review: Just about the greatest upgrade any...