referstorange

  1. D

    RefersToRange error for Mac?

    I have a macro that cycles through each of the named ranges within the workbook to build an inventory or list of names ranges associated with specific worksheets in the workbook. The macro looks to exclude any print areas and any single-cell ranges since I don't need those in the inventory. The...
  2. Carl Colijn

    Error setting value of cells in disjoined named range

    Hi all, I have named ranges that could contain disjoined cell references (e.g. a named range named "MyRange" set to "=Sheet1!A5;Sheet1!B2"). I want to set the value of all cells in these named ranges to certain values via VBA. But when I in turn try to access the actual range in such 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