named array

  1. R

    Paste date from a Named Range to previous column - VBA excel

    Hello, I have named range "H1Range" (lets say H3:H16) and in each run I insert cells before the named range and copy/pastespecial H1Range data in it. Is there a way to string the column which is in the left of Named Range? Thank you in advance
  2. T

    Create dynamic named ranges to call from userform

    Hi, If anyone can give me a kickstart with this it will be appreciated. In the linked excel file there are 2 tabs. I want to work with the first tab, GM SOR's. The first row has identifiers or column headers. The first column, Sub Trade has a number of trades listed multiple times. Each...
  3. C

    triple cascade of drop lists - validation

    Dropdown Lists / Validation rules Trying to input information across three decisions Dept 2. Sector 3. Reason <tbody> E2 F2 G2 dept sector reason Hoist_Pins Infeed Conveyor 1 </tbody> Using named excel tables I have successfully managed to make a...
  4. P

    Named array of variable size

    I want to name an array to use in a formula with Index and Match. Specifically speaking, I have 2 Hidden sheets. Every time the spreadsheet opens, the user is prompted to select 2 files. The contents of each file will be copied onto each of the Hidden Sheets. The problem is that I don't know...

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