absolute reference

  1. S

    Change formula macro

    This one is tricky, Each time I copy selected ROW. I have to change this formula in various columns of row no. 259 =BDP($D$259,"interval_aVG","calc interval=30D","market data override=px_volume",G$204) to =BDP($D$270,"interval_aVG","calc interval=30D","market data override=px_volume",G$204)...
    • sirohiv
    • Thread
    • absolute reference change formula excel macro vba
    • Replies: 2
    • Forum: Excel Questions
  2. E

    Defined Table Absolute In Formula

    Hello - I am working with some dynamic tables. I have named the ranges and graphed them. I am naming the axis with the table name and it is working beautifully: for example: Axis label Range= ='SheetName'!TableName However - I need to make several versions of these and the tables need to...
  3. S

    copy and paste formula without clipboard?

    Is there a way to copy and paste a formula with some vba instead of the clipboard? Every once and awhile, I'll be trying to make duplicate copies of a page in a worksheet so that I have 50 - 100 pages of the same template. Sometimes the formulas copy/paste great with relative referencing. But...
  4. A

    Paste Link with Absolute reference

    Hi All, I have about 43 workbooks. Each have 11 tabs. I am trying to create a new book which has a copy of tab#2 from each book. That would make 43 tabs in new book. I tried to copy those tabs in my new book using Pastelink but it does it with out absolute reference where I want to paste link...

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