vba insert formula

  1. Z

    VBA: Insert Formula Containing an Asterisk "*"

    Hello, I'm having some trouble with inserting a formula using VBA where the formula contains an asterisk (*). My original working VBA code is this: 'Insert Filter Formula ws.Range("A3").Formula2 = "=LET(x,FILTER(CHOOSECOLS(t_" & Name & _ ",13,1,2,20,21,9,10,16,18),COUNTIF(l_OnHand,t_" & _...
  2. D

    VBA Insert Formula based on Worksheet Name

    I have a workbook with multiple worksheets. I need VBA to insert formulas based on the worksheet name. For example: a formula that will reference a value on another sheet in the workbook. The sheet names are assigned dynamically with a 6-digit account numbers added to the existing sheet...
  3. R

    Trying to use VBA to insert a formula into a range of cells within a row

    Hi, I'm trying to use the following code to insert that formula into a range of cells (F:Q) of the rows where "Total" appears on column D. I'm only verifying if "Total" is on column D from row 8 to the last row containing data, which I get using the function LastRowIndex. I'm running excel 2011...

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