.orientation

  1. H

    Run a Macro simultaneously on different workbooks

    Hello Everyone, I have a recorded a short macro and was wondering if anyone can tell me how to run it simultaneously on 10 different excel documents or workbooks? I have Excel 2010. The macro Is as below - Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+a ' Cells.Select...
    • harsh603
    • Thread
    • .orientation activewindow.scrollcolumn end false selection
    • Replies: 0
    • Forum: Excel Questions
  2. H

    Pivot table to select activeworkbook

    I have the following code below which works perfectly to update the Pivot tables Sub Update_Pivot() Sheets("Pivot Table").Select ActiveSheet.PivotTables("PivotTable4").ChangePivotCache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "C:\My...
    • howard
    • Thread
    • .orientation .position end outstanding workbook
    • Replies: 2
    • Forum: Excel Questions
  3. S

    is it Possable to access a hole Pivot table by name for a Pivot Chart?

    Hello once again All, well the Title says it all Here my code: Sheets("Anzahl_Kategorien_je_Kunde").Select Dim PvData As Range Dim PVLastRow As Longt PVLastRow = Range("A" & Rows.Count).End(xlUp).Row PvData = "'Anzahl_Kategorien_je_Kunde'!A1:H" & PVLastRow Cells(1...

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