unused

  1. A

    Retrieving days per month that tanks are empty using filling and emptying dates

    Hi everyone. First post here, so please let me know if anything is not according to the guidelines. This is a snippet from a table in which data is collected from the brewery I work at (not all columns are depicted): batch # tank numberbrew dateempty...
  2. W

    unpopulated blank cells

    Sometimes when working with what looks like cells that look blank they have hidden "0" in it. That messes with formulas at times. So I thought to scrub the worksheet for cells with non visible characters and set them all to the same one. So what I like to know is what state is a new unused cell...
  3. K

    Excel 365 removing querie tables?

    I have just "upgraded" to office 365 and having some problems with some old work books. I use a lot of SQL lookups that are automated by macros. i have found, if the query returns no results any formula that refers to is is broken, with a #REF error. I fixed this by changing refresh option...
  4. M

    How to remove $ and - from unused cells

    Hi folks, as the title says, how can I remove the $ and - from unused cells on my spreadsheet? I've uploaded a pic of what I mean - https://imgur.com/a/hsRQyPV Thanks again,
  5. W

    Adding blank spaced to unused cells

    Please, can anyone tell me why I can not get this to work? ActiveSheet.Range("A2:Z50").Select ActiveSheet.UsedRange.SpecialCells(xlBlanks).Value = " "
  6. M

    Locking(Protecting) Unused Cells

    Hey guys, how to lock(protect) unused cells in a sheet using macro.Sheet data will be dynamic.Thank you.
  7. N

    Single page sheet

    How can I create a single sheet or form that just shows the single sheet? In other words I don't want to see the normal unused columns on the right hand side. It would look like the print preview w/o the RHS cells.
  8. S

    Get next unused sequence number in a group of numbers

    Hi All, I have tried (on line) to find answer to my question but instead totally confused. I would like to Get next unused sequence number 10223 10224 10229 10304 I need to get 10225 Yhank you in advance.
  9. J

    looking for formula to find a "blank slot" in a fixed amount of slots...

    so I have some equipment with 15 fixed slots for each cabinet. I can have up to 5 cabinets in a stack. I can have up to 64 stacks. With that said, I'm looking for a way to take my current configuration and run a macro where it would find the spare slots in each cabinet within each stack and...
  10. C

    Chart - remove unused legend entries?

    Is there a way using vba to delete unused legend entries from a chart legend? What I mean by this is that I have about possible 40 legend entries, which for some reason always are displayed, whether used or not. Often only about 3 to 5 of the legend items will have actual data that appears 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