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...
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...
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...
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...
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.