same worksheet

  1. M

    Repeat VBA Function for Separate Events in Same Worksheet

    Hi all, I am rather new to Visual Basic, but I am trying to duplicate a function that I have wherein if an amount in cell N165 is greater than 5000, then the two rows below the cell (in this case, rows 166 and 167) will become visible. I am trying to do this in multiple separate instances on...
  2. G

    Switching Between Graphs Occupying the Same Cells

    Hello, I'm creating some reports at work, and all the graphs I'm creating are taking up too much room on each sheet. I'm wondering if it's possible to make each graph the same size and lay them on top of each other, and use tabs to flick between them (similar to the tabs at the bottom of the...
  3. C

    query whether values in another tab\named range are contained in a cell

    Not sure it's even possible but would like to be able to accomplish this without the use of VBA or macros (end-user will not be able to maintain if I do). Within the same worksheet basically "query" a list of values in another tab to see if there are any matches. Reason: Specific text could...

Watch MrExcel Video

Learn Excel - "Hide Blank Rows Without a Macro" - Podcast #1736

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