paste formula macro

  1. M

    Formulae not pasting all the way down to end of range

    Hi I've got a spreadsheet that imports new or updates existing using VBA. I then have a Sub which copies the formula in row 1 from columns BY to CL then pastes them into the cells from BY5 to CL5 until the bottom of the range that the new data has gone up to (see below). The new data goes...
  2. R

    Macro for Pasting Formula/Formatting across multiple named worksheets

    Hi guys, I've started a new role that requires me to fix the mess my predecessor created. My current assignment is to fix the formulas and formatting for over a thousand worksheets, spread across multiple workbooks. Each workbook represents a country e.g. 'England' and each worksheet in said...
  3. R

    Macro to paste a formulae using the "ActiveSheet.Name" in the destination cell.

    Hello there. I'm using a macro to paste a formulae into a destination cell on another worksheet. The problem is that I need the Macro to put the "ActiveSheet.Name" into the formulae: ActiveCell=INDIRECT(ADDRESS(MATCH(9E+99+306,ActiveSheet.Name!F:F,1),6,4)) Can you please help me solve...
  4. J

    Macro to paste formula into range of cells

    Hi, I need to paste this formula =AVERAGEIFS(A1:A1000;A1:C1000;"<>0";A1:A1000;"<>A1001") into range of cells so the changes relatively to its position e.g. in column B it will look like this =AVERAGEIFS(B1:B1000;B1:C1000;"<>0";B1:B1000;"<>B1001") The macro I recorded will paste formula...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top