vba formula code

  1. A

    Beginner on VBA Code- hoping for some help.

    Hi everyone, I hope someone can help in constructing VBA scripts for my data: I have this matrix table (see pic attached). I used the following codes to generate the sums of columns and rows vector but not including the diagonal data (shaded in green). I'm a beginner with VBA. I used to...
  2. D

    Formula in Excel to display email message with CC & email receiver

    Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...
  3. M

    Apply Formula To Specific Column for Multiple Sheets in a Filtered Table

    Hi all, I have an issue with renaming cells in a filtered table and would be grateful for some help from the Excel community! Objective: 1. For specific sheets in the workbook, apply a filter in column B:B for a specific number of names Company (Parent) 2. Apply a formula to change the Parent...
  4. Z

    Writing VBA formula

    Hi, Anyone can help me with writing below formula with VBA code? =IF(IF(TEXT(F24, "0") = "", "", IFERROR(INDEX(SF_Goals_Forms!K1:K20000, MATCH(TEXT(F24, "0"), SF_Goals_Forms!CR1:CR20000, 0)), ""))=0,"",IF(TEXT(F24, "0") = "", "", IFERROR(INDEX(SF_Goals_Forms!K1:K20000, MATCH(TEXT(F24, "0")...
  5. O

    VBA Code for Formula

    Thanks in advance for any suggestions for which I will provide feedback. I am getting an error on the following formula as it's when i added, the "N/A" part for the IFERROR. Cells(i, 4).Formula = "= IFERROR( MATCH(TRUE,INDEX(Sheet1!E" & i & ":" & LastColumnLtr & i & "<>0,),0)," & ""N/A" )"...

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