named range copy

  1. J

    Is there way to refer to a Named/Defined range within a macro?

    I have created a number of worksheets that have defined names e.g. a named range called ASX with the following formula... =ASX!$A$1:INDEX(ASX!$AE:$AE,COUNTA(ASX!$AE:$AE),1) Is there a way to refer to this range within a macro so that I can copy the range and paste it into a new workbook? Many...
  2. M

    VBA For copy Named Range (template) to another workbook

    Hello, Is i't possible to copy named ranges from one workbook to an other workbook. The first workbook contains a lot of named ranges and called template. The second workbook has the same structure but not all te named ranges are defined. With a VBA i would like to copy the template to the the...
  3. P

    Stuck in loop Tyring to paste multiple named ranges to a different sheet.

    Hi Guys, I'm pasting values from one sheet to another based on multiple named ranges. Woks great when pasting one column but when i add multiple ranges, UFFF!... Read below... General Overview: I have a sample workbook attached, there are (2) sheets of importance. First is the sheet...
  4. girapas

    Copy named range to another Workbook

    The workbook MyBook1 has a sheet, say DataSheet1, where there is a dynamic range, with the Name "FullNames", that refers to: OFFSET(Datasheet!$C$1;1;0;COUNTA(DataSheet!$C:$C)-1;1). Before closing MyBook1, I want to open another workbook, say MyBook2, and copy the "FullNames" to the sheet...
  5. G

    complex vairable copy paste

    Hi to all: I am trying to copy a named range from a sheet that contains a field named month and year. These fields are not to be copied. What I am trying to do is use the year field to identify the worksheet (ie 2010 so I have a worksheet named 2010) and the month field is controlled by a list...

Watch MrExcel Video

This Week's Hot Topics

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
Top