4.select

  1. R

    Looping through all Slicers in Workbook

    Hello all, I have a workbook with about 100 pivot tables (no joke) and I need to change all the slicers associated with them to 'Don't move or size with cells'. When I record a macro to change 2 slicers on 1 sheet attached to 1 pivot table I get this: ActiveSheet.Shapes.Range(Array("Entity...
  2. D

    Need help turning my script into a loop

    Hey guys.....:) Is there a way to turn this into a loop?:confused: Worksheets("Data Entry").Select ActiveSheet.Shapes.Range(Array("Picture 2")).Select Selection.Copy Range("R2").Select ActiveSheet.Pictures.Paste.Select Worksheets("Data Entry").Select...
  3. N

    If cannot find string...set to 0

    Hi, Stuck writing the IF statement for the following code 'Total Wins findrow = Range("A:A").Find("Career").Offset(0, 4).Select ActiveCell.Copy Range("T5").PasteSpecial findrow2 = Range("A:A").Find("2017-18").Offset(0, 4).Select ActiveCell.Copy Range("T4").PasteSpecial Range("T3").Value =...
  4. B

    Formula Array Not working with variables

    I'm trying to use a formula array to do some calculations.. this works.. Range("C" & LastRow + 4).Select Selection.FormulaArray = _ "=PERCENTILE(IF(L2:L" & LastRow & "=""15"",AC2:AC" & LastRow & "),0.4)" but when I try to replace the 15 with a variable (year) it just...

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