+ Reply to Thread
Results 1 to 5 of 5

Do multiplication through VBA code

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Do multiplication through VBA code

    in the attached file you can see VBA code this code given by Mr.Bo_ry in this forum i posted thread on date 1 february 2021 and heading is
    "Do sum at a time when selecting whole column"
    now i want some modification to this VBA code, i want that do multiplication of column D and E it means multiply D with E then result should relfected in column F then do sum of column F data, sum should appear exactely bellow that data,
    code which is in attached file only can did sum of F column data
    but i need to do multiplication of D column and E column manualy which i want to do through VBA code,
    see before after sheet so you can easily understand what i want
    Attached Files Attached Files
    Last edited by keshavtale; 02-05-2021 at 10:46 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Do multiplication through VBA code

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: Do multiplication through VBA code

    Thanks again, just do one thing can you apply formating to multplied values it means result of D multplied by E column which result appear in F column apply formating that values of F column formating like font cambria, font size 12 and appy border
    Last edited by keshavtale; 02-05-2021 at 01:20 PM.

  4. #4
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: Do multiplication through VBA code

    Thanks again, just do one thing can you apply formating to multplied values it means result of D multplied by E column which result appear in F column apply formating that values of F column formating like font cambria, font size 12 and appy border

  5. #5
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: Do multiplication through VBA code

    Thanks again, just do one thing can you apply formating to multplied values it means result of D multplied by E column which result appear in F column apply formating that values of F column formating like font cambria, font size 12 and appy border

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code to Add multiplication formula till the last row
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2019, 05:20 PM
  2. [SOLVED] Multiplication excel code formula
    By RJ1969 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2018, 04:50 PM
  3. IF/or with multiplication
    By BoudeyCall in forum Excel General
    Replies: 8
    Last Post: 02-03-2017, 03:01 PM
  4. VBA Looping code help need for Multiplication Table in UserForm
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2011, 02:04 PM
  5. Converting simple multiplication formula in VBA code
    By Saky in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-07-2010, 07:33 AM
  6. Help with multiplication
    By GatorRaucous in forum Excel General
    Replies: 3
    Last Post: 02-07-2009, 04:44 PM
  7. [SOLVED] multiplication
    By gem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2006, 03:55 AM

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