srcwb

  1. M

    Unprotect copied protected sheets and paste a range as value

    Hi All I have this code below, I'm trying to figure out how i can copy protected sheets and unprotect together with copying a specific range and pasting it as value only. Hoping for a quick response. Thank you! ? Sub CopySheets() Application.ScreenUpdating = False Dim MyFolder As...
  2. A

    VBA to copy worksheets from another workbook

    Hello All, i am trying to copy all the worksheets from and external workbook saved in another folder into current workbook. So far, I have this: Sub CopyWorksheets() Dim sh As Worksheet, srcwb As Workbook, trgtwb As Workbook, strng As String strng = "S:\Planning and scheduling\Rosters\Master...
    • asad
    • Thread
    • copy srcwb strng workbook worksheets
    • Replies: 7
    • Forum: Excel Questions
  3. M

    Cannot access named Range contained value after Workbook.open

    Hello everyone, I am trying to execute a macro from another workbook after opening it with Workbook.open. The macro works fine when I execute it after opening the workbook manually but whenever I open it from another workbook, I become the following error: "VBA Runtime Error 1004...

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