+ Reply to Thread
Results 1 to 6 of 6

macro to read the contents from 2 columns(A &B) and display the results in thiRD column(c

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    11

    macro to read the contents from 2 columns(A &B) and display the results in thiRD column(c

    hi,

    i have 2 columns

    A.B

    i just want to multiply A*F and the result need to come in "H" and total of columm "H" need to come in column "I"

    i tried the following code.But it only reads only first row.
    pls help
    Manoj



    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Cutter; 08-16-2012 at 07:22 PM. Reason: Added code tags

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: macro to read the contents from 2 columns(A &B) and display the results in thiRD colu

    You need to replace "h2" with "h" & i and so on for the rest of your ranges,

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    07-06-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: macro to read the contents from 2 columns(A &B) and display the results in thiRD colu

    dear sir,

    it is showing type mismatch "13"
    runtime error

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: macro to read the contents from 2 columns(A &B) and display the results in thiRD colu

    I dont know why? This works for me

    file.xlsm

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: macro to read the contents from 2 columns(A &B) and display the results in thiRD colu

    @ manojktvm

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.

  6. #6
    Registered User
    Join Date
    07-06-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: macro to read the contents from 2 columns(A &B) and display the results in thiRD colu

    dear sir,
    i changed the data types in cells.now it is working.

    nice

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1