VBA Multiply 2 column

**robyrubyjane** · 03-29-2023, 04:56 AM

hi guys, so I have 3 Columns, RF, MF and REVENUE. so when I click the multiply button the vba will multiply column RF with MF and the result will be in Column Revenue. I have 40000 rows so instead of define range like .range(1:40000), can I just like autofil range without need to define the range manually? so when the rows get added macro will automatically multiply the vcolumns?

**CheeseSandwich** · 03-29-2023, 05:01 AM

As pointed out in your other thread for the same thing, you can just put this formula into range C2:

Formula:

Please Login or Register  to view this content.

VBA Multiply 2 column

LinkBack

Thread Tools

Rate This Thread

Display

VBA Multiply 2 column

Re: VBA Multiply 2 column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count certain numbers in column then multiply by sum of other column linked to first.

Formula to multiply value in one column by amount dependent on value from another column

If/Then (For Rows in Column A containing year, multiply corresponding cells in Column C)

[SOLVED] Formula to multiply column with a dynamic column

Find last non-blank value in column, multiply by value in same row, diff column

Look up a cell value in a column the multiply the result by a corresponding column

Multiply every nth cell by another column whith merged cells, THEN find column total

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions