stupid

  1. R

    All possible combination of one column list

    Hi Experts, I need a help from you on the below. I need to calculate all possible combination of the below: "5L","5R","4L","4R","3L",3R","B2","B3","B4". I would need a possible combination of 2 of each up to 9 of each and no duplicates. I'm fairly new to excel so please forgive me if this is...
  2. T

    Macro to stop a Workbook being saved anywhere but its current location and name

    Hi Everyone, I need help, once again despite my best effort people have suppased my expected level of stupid. Whats happening is they are opening a document then saving a copy in a different location. I've gotten past the problem of them doing this in the folder by using a shortcut and saving...
  3. M

    Clea Contect macro not working

    Apologies for the title typos :-/ The code is supposed to look at column K, and for each blank cell, the contents of columns B:J should be blanked out. I'm not great with VBA and have pieced this together from other code so I'm sure its something stupid.............. TIA Sub ClearRows()...
  4. M

    Clicking and Dragging enters a random formula - anyone know what is happening?

    Hi All, When I try and click and drag to select cells to copy (for example) if I have to drag to make the page scroll down Excel keeps entering this weird formula and it is really difficult to get rid of - does anyone know why it is happening (or what stupid thing I am doing???) Pic of example...
  5. A

    display filtered records count right next to want-to-filter-list (pic inside)

    hi everyone, (maybe a stupid question) i just want to know, is MS Excel able to do this (as title said):
  6. Futile Crush

    Irreparable Error with TRANSPOSE function

    Hey guys, I'm in a bit of a pickle with Excel. I made the dear mistake of succeeding in using the TRANSPOSE function, just to copy 10 rows which I easily could have typed out. But then, I wanted to insert a column, it wouldn't let me, so I decided to take the latter columns out of the equation...

Watch MrExcel Video

This Week's Hot Topics

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
Top