formula range

  1. B

    Formula range changes when linked table is refreshed

    Greetings! I have a table linked to Access, with a column I inserted into the Excel table, so I could use a formula. However, when I refresh the table, the range in the formula changes. Nothing else in the formula changes, just the range. Here is the formula as it should be: Cell T3...
  2. O

    Getting formula from excel

    I would like to read a formula from excel range object and use it in VBA macro for optimization with my own algorithm. The Excel Solver add-in do something similar.

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