mode

  1. J

    Alternative method fo simple function?

    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...
  2. J

    Finding most common words in excel

    Hi there, 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...
  3. T

    Autosave Macro when doc is not read only

    Hi there, 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...
  4. Z

    mode

    Trying to use mode on data with negatives times. <colgroup><col span="2"></colgroup><tbody> -0:11 #value ! -0:06 #value ! -0:03 #value ! -0:05 #value ! 0.01 0:08 0.00 0:00 0.00 0:01 The #value is removing the seconds if present formula INT(CJ15*1440)/1440 I'm removing seconds...
  5. L

    design mode

    Hi I want to understand Developer-->Design mode and what is used for. I read this post https://www.mrexcel.com/forum/excel-questions/32669-design-mode-vba.html and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...
  6. Z

    Restrict Print Until Some Conditions are made

    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...
  7. Y

    How to get into that edit mode?

    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...
  8. H

    Macro works in Debug mode but not in Runtime

    Sub Create() 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") For...
  9. Y

    exiting array formula evaluation mode

    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?
  10. D

    Most common number that follows a specified value in a list

    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 E.g. If C1=10 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 eg B2=10 B3=5 B4=4...
  11. D

    Most common number that proceeds a specified value in a list

    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 E.g. If A1=10 Then B1 will show the mode each number in a range B2:B100 that proceed a 10
  12. G

    Stop Excel from Opening in Full Screen Mode (Office 365)

    I have Office 365. Whenever I start Excel or open a new file with Excel, it opens (or goes to) full screen mode. I can find no way to stop this from happening. Any ideas?
  13. D

    Saving in Developer mode vs saving in spreadsheet

    Hi All, 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...
  14. D

    Excel VBA Macro works on Step Into Mode but not in Run Sub Mode

    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. I am...
  15. J

    If Cell Is Blank, Fill With Other Cell’s Text Data

    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...
  16. A

    File corupt

    Hi. 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...
  17. gmooney

    Excel VBA Open PowerPoint into slideshow mode

    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 PPT.Presentations.Open...
  18. T

    INDEX MODE MATCH and INDIRECT

    Please help 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...
  19. S

    Mode calculation if there is blank cells

    I am trying to calculate the most reoccurring text in cells that contain blank cells Code I tried =INDEX(A2:A20,MODE(IF(A2:A20<>"",MATCH(A2:A20,A2:A20,0)))) but I am struggling to find what condition to use to remove counting the blank cells. Any suggestions Thank
  20. C

    Combining Vlookup and IFS

    Good afternoon. I have two tables as follows: Table 1 has a client's name, and pack mode. The pack mode can be any of three items (FCL, LCL or LSE) table two has two columns, one for pack mode and one for the related price. Each pack mode has its own price. I need to do a vlookup in table 1...

Some videos you may like

This Week's Hot Topics

Top