In the below example I am trying to work out in what week the credit can be taken, based on the total invoice value (by customer) exceeding the credit value.
I have tried variations of MODE, MAX and INDEX but no success.
any suggestions would be greatly received. :)
Hi all, i have the below piece of code that i run every 200 milliseconds. It works fine however i am looking for a better, more efficient way of producing the same result. I use AutoHotKey to get information from Excel and quite often i will get a Callee error, i assume this is because Excel is...
I have several survey question responses. Many of them are paragraphs in single cells. I am wondering if there is a way for excel to look at every word (not just the cell as a whole) and return the most common words.
The problem I am running into is that I want to look at each...
I am somewhat new to macros but getting better each day, much thanks to this forum. I have been fighting a macro for a while so I thought I should ask.
I would like a macro that autosaves the current workbook every 5 minutes without opening a dialog box or whatnot. Just as if they...
Trying to use mode on data with negatives times.
The #value is removing the seconds if present
I'm removing seconds...
I want to understand Developer-->Design mode and what is used for. I read this post
and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...
Good Afternoon Mates!
I want to make an excel sheet which will not allow the user to take print until the the latest changes are saved.
Actually I have created a file which requires "password to modify". Without entering the password, one can access the file with "Read Only" mode. But, in read...
In edit mode, when one letter is highlighted and left or right arrow key is pressed, usually, no letter is highlighted anymore. However, recently, I highlighted a letter, pressed an arrow key, and the next letter was highlighted. This is quite handy if I need to replace several letters in a...
Dim i As Long
Dim xNumber As Integer
Dim xName As String
Dim xActiveSheet As Worksheet
On Error Resume Next
Application.ScreenUpdating = False
Set xActiveSheet = ActiveSheet
xNumber = InputBox("ENTER NUMBER OF TIMES TO COPY THE CURRENT SHEET")
To see the evaluation of an array formula, one can highlight the array formula and hit F9. Hitting ESC should exit the evaluation mode and go back to display the array formula. It has happened to me a few times that ESC doesn't show the array formula. I was stuck in the evaluation mode. Any way out?
I want to enter a formula in cell B1
This formula will show the MODE of the values in a range that follows a specified number in C1
Then B1 will show the mode of numbers that follow 10 in a range B2:B10. Which would be 5.
If C1=5 then B1 would equal 4
I want to enter a formula in cell B1
This formula will show the MODE of the proceeding values that I specify in cell AI
Then B1 will show the mode each number in a range B2:B100 that proceed a 10
Just curious is there a difference in saving in Developer mode to saving in Workbook mode?
The reason I ask is I was working on a (for me) complex VBA script and would meticulously click the "Save" button in Developer EVERY single time I made a change.
I had to run an OS update (on my...
When running a macro in "Step Into" mode it performs correctly. When running the same macro in "Run Sub" mode it fails every time. In the "Run Sub" mode I receive an "Exception occurred." error message followed by "Run-time error '1004': Method 'Range' of object'_Global' failed" message.
This is probably simple for you experts out there. I've tried so many ways, and in so many locations w/in the code, but none are working for me. Please help!
All I’m trying to do is get data from CELL RANGE B4:B4000 to copy automatically to CELL RANGE J4:J4000 should CELL RANGE J4:J4000 be...
I need your help.
I have spend a lot of time on my daily report excel project, and as it was getting to over, in my final file, it got corrupt and excel can not open it anymore, and massage me like excel has stop working. I try to recover it with excel auto recovery tools but it didnt work...
Taking this code I would like to add the ability to have the PPT automatically open in slideshow mode:
Private Sub MonthlyToplinePPT()
' Opens Presentation.pptx
Dim PPT As Object
Set PPT = CreateObject("PowerPoint.Application")
PPT.Visible = True
I am trying to correct the below formula as I would like to use INDEX MODE MATCH with INDIRECT in a array.
The below works, but if I enter a new line at the top of my data set (EIRF Tracker Row 9-2150) the MODE and MATCH arguments change to read from row 10-2151 still...
I am trying to calculate the most reoccurring text in cells that contain blank cells
Code I tried
but I am struggling to find what condition to use to remove counting the blank cells.