Code for adding 2 numbers from another WB

**siggisigg** · 07-16-2014, 08:54 AM

Hi,
I have a code that opens another WB, and gather data from it. most of the lines look like this

HTML Code:

However i need it to gather the sum: M49+M50, how can i do this without importing both values and then adding them in a 3rd column, like i am currently doing

**Trebor76** · 07-16-2014, 09:00 AM

Hi siggisigg,

This will put the result in a message box - use the dblMyVal variable for whatever purpose you need:

Please Login or Register  to view this content.

HTH

Robert

**siggisigg** · 07-16-2014, 09:04 AM

I just need it to be put in the first row without data in column K. Do i need to make a variable as a temp. holder to do it ?

**Trebor76** · 07-16-2014, 09:41 PM

Try this:

Please Login or Register  to view this content.

Or via my variable method:

Please Login or Register  to view this content.

Robert

Code for adding 2 numbers from another WB

LinkBack

Thread Tools

Rate This Thread

Display

Code for adding 2 numbers from another WB

Re: Code for adding 2 numbers from another WB

Re: Code for adding 2 numbers from another WB

Re: Code for adding 2 numbers from another WB

Thread Information

Users Browsing this Thread

Similar Threads

Adding Text to another cell VB code (Help Tweeking code) (Excel 2007)

[SOLVED] Adding XML kind of code in Exce; VBA Code module

Adding cell zoom code to already existing code in single worksheet

Code writes decimal numbers next to each other instead of adding

adding area code to phone numbers

Bookmarks

Bookmarks

Posting Permissions