worksheet active

  1. M

    Call all procedures of a worksheet module that relate to the active worksheet name

    Dear Users, I'm trying to run the code here: Stack Overflow When you press a button it checks the active worksheet and tries to run all the code in the worksheet object in Microsof Excel Objects that has the same name. I tried running it but I get a Subscript Out of Range Error. Thanks...
  2. C

    Macro questions

    I have some questions about this macro, that I used to make a chart. I'm a newbie creating macros. Thanks so much and sorry for so many questions. How do I make this macro work on a different user's computer? ActiveChart.ApplyChartTemplate ( _...
    • cralx2k
    • Thread
    • chart macro template external data worksheet active
    • Replies: 0
    • Forum: Excel Questions
  3. J

    Export multiple worksheets as CSV with worksheet name

    What do I add to this code to export my worksheets with their worksheet name? Currently it shoots them out as Sheet1, Sheet2, Sheet3 etc... Sub ExpCsv()Dim i As Integer For i = 1 To 3 Sheets(i).Activate Range("A1:W645").Copy Workbooks.Add ActiveSheet.Paste ActiveWorkbook.SaveAs...
  4. S

    How to update range when active sheet is not active any more

    Hello, trying to update a range in another worksheet, but only when the active worksheet is not selected anymore. Ie, 4 worksheets in my workbook, sheet1...sheet4. When user changes something in sheet4, then selects sheet3, I would like vba code to update a range in sheet1. But this can only...

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