decided

  1. D

    Find current week number from 2 different listboxes

    Hi, I had a listbox (ListBox1) with all 52 weeks of the year in and Fluff very kindly supplied me with this code that worked perfectly for me: Me.ListBox1.Selected(Application.WeekNum(Date) - 1) = True But because the listbox was so long I have decided to use 2 listboxes (ListBox1, ListBox2)...
  2. M

    Pivot Range has changed?

    Hi Not sure how else to find out other than asking on here. Ive inherited a report which im currently fixing as the pivot tables have all decided to resize themselves and instead of looking at the full range of data has changed to only 2 columns. Anyone know why this might have happened? Thanks
  3. HolliIsAwesome

    I have come out from the shadows

    to intro myself! I feel like I have stepped on sacred ground! :laugh: I work from home supporting professionals and one of them needs me to learn Excel, right - always been a novice. Then I got this big project to put together a merge with autofields based on other autofields or formulas... and...
  4. J

    Determine the most frequent item in an array.

    Hello, Does anyone have a readily code or function that determines the most frequent item in the array ? I think it will take me a while to come up with it. I created an array Dim ar(50) It stored up to 50 items, sometimes the items can all be the same, other times it could be different...

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