I thought this would be simple but my attempts are not working for me. I need two things PLEASE.
I am trying to calculate the total number of "days" between two dates, and secondly, calculate the number of "week days" between the same dates. Each would be in a separate cell. I am totally...
Hey guyz,
I am working on VBA environment, would like to keep my notepad open all the time without switching the active screen.
Is there any way we can do this ?
Dinesh S
I feel silly asking this but I just cannot figure it out. I have a macro workbook set up with form control buttons to pick the module you would like to run. The issue I am having is getting the macro to activate a different window regardless of the file name as the file name is different for...
My PT isn't updating after switching my data sources. It might be that my Pivot Cache isn't updating.
If I go into my immediate Window (VBE) what one-line statement can I type to Update my Cache?
TIA,
Jim
Hi,
I have been passed a problem by a colleague. They use Find to locate a cell, then enter a value alongside this cell but these values do not display in the cell. They do display in the formula bar.
The values appear when switching to another sheet and back again.
This only seems to occur...
So in a spreadsheet that we have to continuously update that my colleague just handed over to me, I just discovered that the Formulas Calculation Option was changed from Automatic to Manual. I would like to know if there are any instances that such switching can occur on its own without someone...
Hi,
I am running excel 2010 on windows 7 and due to the memory limitation in one session of excel (ours keel over when they hit 900MB) we are forced to run 2 separate instances.
In each of the sessions we have a number of workbooks open. The problem we have is quickly switching from a...
I'm doing a ton of corrections for mixed up information. Is there a function that will cut and paste a cell's contents and automatically push the destination's cells contents to the original cell that you cut from? i.e. - Swapping contents...
if that does exists, I'd assume I could assign a...
Hi, i tried to solve a problem appeared to me before and another came up.
I have set a UserForm with ComboBox for multiple selection items. I use 4-5 subroutines in a row so the UserForm user to select a specific value. Depended ComboBox in other words. The error i get is that of "Subscript out...
Hi there,
I am currently working on an Excel presentation, using buttons to display 3 charts on 3 separate sheets. Please advise on formulas I could use with the buttons to switch between the charts.
thanks
I frequenly have two Excel spreadsheets open so I can copy and paste data between them. For some reason, when I alt-tab between the spreadsheets, sometimes a portion of the spreadsheet is pure white... almost as if that part of the spreadsheet hasn't "refreshed" yet. If I minimize it and then...
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.