moving sheets

  1. K

    Moving sheets between workbooks with the same named ranges

    I have two workbooks, each containing a similar "Reference" sheet of global constants, which are defined in about 100 named ranges. The named ranges are the same in each workbook and are scoped at workbook level so they can be used by other sheets in each workbook, but the global constants...
  2. V

    Move sheet with new name to another (closed) workbook.

    Hi forum, it seems easy enough...NOT. With the following code I intend to -move a sheet to another workbook, -rename it (actually, with a name consisting of cells "A9" and "_" and "H8" of said sheet) -place the sheet at the beginning of the workbook it was moved to, -and continue with the...
  3. C

    move sheets until last one

    Hi, I am trying to navigate from one sheet to next in a loop until the last sheet where it should stop the loop. There are 24 sheets in total and I keep getting an error at the last sheet. How to fix? Do While IsError(Sheets.Count) = False Sheets(ActiveSheet.Index + 1).Activate Loop Regards...
  4. B

    VBA: Moving Sheets: Variable Names

    Hi, Having cobbled together the following I'm snagged on how to move a sheet in the active workbook to another open workbook which I do not want to explicitly type the name of. 'Move sheet to target book ActiveSheet.Move Before:=Workbooks(XXX).Sheets(1) Where XXX on other forums can be...

Watch MrExcel Video

Learn Excel - Pivot From Many Sheets: Podcast #1331

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