LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Multiply cells in range by corresponding factor

I'm a beginner at writing VBA macros and I need some help. What I want
to do is to provide the ability to select a range of cells in a
spreadsheet then click on a command button that runs a macro that
multiplies the content of each cell in the selected range by a
corresponding factor identified in row 2 of each column.

(Example) In row 2 the cells contain (A2)5,(B2)5 and (C2)10; Cells
A4:C5 contain values (A4)1,(B4)2,(C4)3,(A5)2,(B5)3,(C5)1. I select
range B4:C5. After running the macro the cells now contain
(A4)1,(B4)10,(C4)30,(A5)2,(B5)15,(C5)10.

If anyone could provide the code to perform this task I could use your
help. Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiply range of cells by a fluctuating exchange rate Oliver Excel Discussion (Misc queries) 8 September 3rd 06 09:07 AM
How to multiply all cells in array by factor rhauff Excel Discussion (Misc queries) 2 March 21st 06 03:01 PM
multiply all values in all cells by a factor [email protected] Excel Discussion (Misc queries) 1 March 14th 06 09:51 PM
Would like one cell to both count and multiply a range of cells golfer18 Excel Worksheet Functions 2 February 27th 06 03:33 AM
Multiply one cell by a factor and make that result round Machel_C Excel Worksheet Functions 7 March 15th 05 08:04 PM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"