Results 1 to 6 of 6

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

Threaded View

manojktvm macro to read the contents... 08-16-2012, 05:02 AM
mike7952 Re: macro to read the... 08-16-2012, 05:15 AM
manojktvm Re: macro to read the... 08-16-2012, 07:39 AM
mike7952 Re: macro to read the... 08-16-2012, 07:45 AM
Cutter Re: macro to read the... 08-16-2012, 07:23 PM
manojktvm Re: macro to read the... 08-17-2012, 06:03 AM
  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



    Sub Button51_Click()
    RowCounter = Intersect(ActiveSheet.UsedRange, Columns("A:F")).Rows.Count
     For I = 1 To RowCounter
     
     Worksheets("dataentry").Range("h2").Value = Worksheets("dataentry").Range("d2").Value * Worksheets("dataentry").Range("f2").Value
    
    Next I
    
    End Sub
    Attached Files Attached Files
    Last edited by Cutter; 08-16-2012 at 07:22 PM. Reason: Added code tags

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