sourcename

  1. E

    Move Data from one sheet to the other

    I have the following code that copies the rows from one my source sheet to the other and gets rid of empty rows that don't have anything in column C. I want to be able to run this so that if my target sheet has data to place it at the last empty row. if possible, I also want it to check every...
  2. E

    Updating Excel OLEObjects SourceName

    First time posting, really hoping someone will be able to help. I am new to working with VBA and OLE Objects for work and I am having issues finding a better way to update the Object SourceName. The reason why it changes often is I have a "Master" file with blank linked files that are copied...
  3. N

    Refresh row headers in pivot tables with vba

    Hello, I need to refresh (i.e. in this case: use the SourceName again) row headers in pivot tables with vba. I found code (probably written with a former version af Excel): Public Sub piv_kor() Dim wS As Worksheet Dim pT As PivotTable Dim pF As PivotField Dim pI As PivotItem For Each wS In...

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