.formula

  1. C

    Strange VBA problem with Cells.Formula: evaluation results in error

    Dear all, Can somebody tell me why .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula = "= " & .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula & " + " & .Cells(646 + daysconcerned, 18).Value results in an error? The error code is 1004: error defined by application or...
  2. A

    VBA to insert a formula into a cell

    Hi everyone, I have a question about the .Formula command. I have a macro which works correctly, so my question is actually about my understanding/learning and cleaning my code up: not making the code work. Quick scene-setting: I have a long formula that concatenates several pieces of text...
  3. N

    easy formula = HARD with ".Formula" property in VBA

    Here's a formula I'm using: =IF(tree.1!$A1<>"",tree.1!$A1,"") Basically, I'm copying data from one sheet to another (please, don't ask me how I got myself into this situation!), and trying to avoid 0s for blank cells. Problem: I have to do this to 10,000s of cells, so I had a handy...

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