screens

  1. R

    Reference a column with variable rows with vba

    hello i have some code that is supposed to look at a specified sheet and figure out how many active rows it has and then look at column D and check each cell in that column to see if any are over 55. if any cell is over 55 it will give a message box as you can see... with this code it is giving...
  2. J

    Streamline Macro Code for filtering, copying, and pasting

    Hi there, below is the code I have in the excel file. Basically what it does it starts with one tab full of data, creates 3 new tabs, and then filter/copy/paste information from the original data set to each of the 3 new tabs based upon different attributes. It also adds a new "date" column to...
  3. P

    Access file to open form only

    Hi All, After some help from Joe off this forum i have manged to put together a basic form that i would like other users to use, but i dont want them to be able to get to any of the editing screens or see the raw data behind the form. Is there anyway that the form can be saved as if its a stand...
  4. S

    Lost spreadsheets

    The file icon is on my desktop. When I open the file, excel opens...but instead of having a spreadsheet, the screen is gray. I KNOW that the data is there, I just can't FIND it! I have expanded the workspace as much as it will grow, and given my screens the maximum resolution that I can in hopes...
  5. A

    UserForm Dual Screen BOTH screens

    From searching, I see there's a plethora of data on UserForms in dual screen environments, such as centering on the window, displaying on the proper screen, etc. But here's my question: Can I make a Userform take up BOTH screens? I want it to be maximized to the fill the entirety of both...
  6. K

    Viewing pivot sheet & chart on two monitors

    I have a dual-monitor set-up, which is useful for comparing two workbooks side by side (if each is opened in its own instance of excel). I have a fairly intricate pivot table (and chart) that I want to be able to manipulate data on my primary screen and see the results in the chart on my second...

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